Returns the serial number of the time represented by time_text. The serial number is a decimal fraction ranging from 0 (zero) to 0.99999999, representing the times from 0:00:00 (12:00:00 A.M.) to 23:59:59 (11:59:59 P.M.). Use TIMEVALUE to convert a time represented as text into a serial number.
Syntax
TIMEVALUE(time_text)
Time_text is a text string that gives a time in any one of the Microsoft Excel time formats. Date information in time_text is ignored.
Remarks
Microsoft Excel for Windows and Microsoft Excel for the Macintosh use different date systems as their default. For more information about date systems and serial numbers, see NOW.
Examples
TIMEVALUE("2:24 AM") equals 0.1
TIMEVALUE("22-Aug-55 6:35 AM") equals 0.274305556