Practice free

TIMEVALUE function

TIMEVALUE converts a time stored as text into a numeric time, a fraction of a day, that you can calculate with. Any date in the text is ignored.

Example

Read it as a sentence: turn the text 6:00 PM into a time value, which gives 0.75.

Practice this in the app

Syntax

TIMEVALUE(time_text)

time_text (required)
Text that looks like a time, such as "6:00 PM".

Returns: A fraction of a day.

What Excel actually returns

Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.

FormulaExcel showsCase
=TIMEVALUE("6:30 PM") 0.770833333 12-hour text
=TIMEVALUE("18:30:15") 0.771006944 24-hour text
=TIMEVALUE("1/9/2026 6:00") 0.25 Date part ignored
=TIMEVALUE("25:00") 0.041666667 Over 24 hours
=TIMEVALUE("10:61") 0.459027778 Bad minutes
=TIMEVALUE("1/9/2026") 0 Date only text
=TIMEVALUE("abc") #VALUE! Bad text
=TIMEVALUE(0.5) #VALUE! Number instead of text

Watch out for

  • Any date portion in the text is ignored.
  • Unreadable text gives #VALUE!.

Where it works

Excel
TIMEVALUE is in every version of Excel from 2007 on.
Google Sheets
Same name, same behaviour for everyday use.

Part of Date and time functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .