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.
A
B
C
D
1
0.75
2
3
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.
| Formula | Excel shows | Case |
|---|---|---|
=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 .