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
Date information in time_text is ignored.
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) |