



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


  • Date information in time_text is ignored.



ShowHow to copy an example

  • Create a blank workbook or worksheet.
  • Select the example in the Help topic.

 Note   Do not select the row or column headers.

Selecting an example from Help

Selecting an example from Help
  • Press CTRL+C.
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   To view the number as a time, select the cell and click Cells on the Format menu. Click the Number tab, and then click Time in the Category box.

Applies to:
Excel 2003