TIMEVALUE

Returns the decimal number of the time represented by a text string. The decimal number is a value ranging from 0 (zero) to 0.99999999, representing the times from 0:00:00 (12:00:00 AM) to 23:59:59 (11:59:59 P.M.).

Syntax

TIMEVALUE(time_text)

Time_text   is a text string that represents a time in any one of the spreadsheet time formats; for example, "6:45 PM" and "18:45" text strings within quotation marks that represent time.

Remarks

Example

Formula Description (Result)
=TIMEVALUE("2:24 AM") Decimal part of a day, for the time (0.1)
=TIMEVALUE("22-Aug-2008 6:35 AM") Decimal part of a day, for the time (0.274305556)