TIMEVALUE

Date/Time Functions:
Function: DATEVALUE() - Converts a time in the form of text to an Excel serial number.
(A1) Time String: 3:15
Formula: =TIMEVALUE(A1)
Excel TimeStamp: 0.13541666666667
Formatted TimeStamp: 03:15:00

(A2) Time String: 13:15
Formula: =TIMEVALUE(A2)
Excel TimeStamp: 0.55208333333333
Formatted TimeStamp: 13:15:00

(A3) Time String: 15:15:15
Formula: =TIMEVALUE(A3)
Excel TimeStamp: 0.63559027777778
Formatted TimeStamp: 15:15:15

(A4) Time String: 3:15 AM
Formula: =TIMEVALUE(A4)
Excel TimeStamp: 0.13541666666667
Formatted TimeStamp: 03:15:00

(A5) Time String: 3:15 PM
Formula: =TIMEVALUE(A5)
Excel TimeStamp: 0.63541666666667
Formatted TimeStamp: 15:15:00

(A6) Time String: 5PM
Formula: =TIMEVALUE(A6)
Excel TimeStamp: 0.70833333333333
Formatted TimeStamp: 17:00:00

(A7) Time String: 9:15AM
Formula: =TIMEVALUE(A7)
Excel TimeStamp: #VALUE!
Formatted TimeStamp: #VALUE!

(A8) Time String: 13:15AM
Formula: =TIMEVALUE(A8)
Excel TimeStamp: #VALUE!
Formatted TimeStamp: #VALUE!