TIMEVALUE

See Also

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

The example may be easier to understand if you copy it to a blank spreadsheet.

How?

  1. Create a blank spreadsheet.
  2. Select the example in the Help topic.

    Selecting example from Help

    Selecting an example from Help

  3. Press CTRL+C.
  4. In the spreadsheet, select cell A1, and press CTRL+V.
  5. 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.