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
The example may be easier to understand if you copy it to a blank spreadsheet.
How?- Create a blank spreadsheet.
- Select the example in the Help topic.
Selecting an example from Help
- Press CTRL+C.
- In the spreadsheet, select cell A1, and press CTRL+V.
- To switch between viewing the formula that returns the result and the result in the cell, select the cell and press F2 and then ENTER, or click Commands and Options on the spreadsheet toolbar, click the Formula tab, and look in the Formula in active cell (active cell) box.
| 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) |
Note If you want to change the display of the result from a serial number to a time format or vice versa, select the cell and click Commands and Options
on the toolbar. Click the Format tab and then select the format you want in the Number Format box. To view the date as a serial number, apply the General number format.