TIMEVALUE

02:44:49 Converts a time in the form of text to a serial number.
02:44:49 Time String: 3:15
02:44:49 Formula: =TIMEVALUE(A1)
02:44:49 Excel TimeStamp: 0.13541666666667
02:44:49 Formatted TimeStamp: 03:15:00
02:44:49
02:44:49 Time String: 13:15
02:44:49 Formula: =TIMEVALUE(A2)
02:44:49 Excel TimeStamp: 0.55208333333333
02:44:49 Formatted TimeStamp: 13:15:00
02:44:49
02:44:49 Time String: 15:15:15
02:44:49 Formula: =TIMEVALUE(A3)
02:44:49 Excel TimeStamp: 0.63559027777778
02:44:49 Formatted TimeStamp: 15:15:15
02:44:49
02:44:49 Time String: 3:15 AM
02:44:49 Formula: =TIMEVALUE(A4)
02:44:49 Excel TimeStamp: 0.13541666666667
02:44:49 Formatted TimeStamp: 03:15:00
02:44:49
02:44:49 Time String: 3:15 PM
02:44:49 Formula: =TIMEVALUE(A5)
02:44:49 Excel TimeStamp: 0.63541666666667
02:44:49 Formatted TimeStamp: 15:15:00
02:44:49
02:44:49 Time String: 5PM
02:44:49 Formula: =TIMEVALUE(A6)
02:44:49 Excel TimeStamp: 0.70833333333333
02:44:49 Formatted TimeStamp: 17:00:00
02:44:49
02:44:49 Time String: 9:15AM
02:44:49 Formula: =TIMEVALUE(A7)
02:44:49 Excel TimeStamp: 0.38541666666667
02:44:49 Formatted TimeStamp: 09:15:00
02:44:49
02:44:49 Time String: 13:15AM
02:44:49 Formula: =TIMEVALUE(A8)
02:44:49 Excel TimeStamp: #VALUE!
02:44:49 Formatted TimeStamp: #VALUE!
02:44:49