TIMEVALUE
Converts a time in the form of text to a serial number.
Time String
Formula
Excel TimeStamp
Formatted TimeStamp
3:15
=TIMEVALUE(A1)
0.13541666666667