Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
TIMEVALUE
TIMEVALUE parses a text string that looks like a time and returns the equivalent decimal serial number, where 0 = midnight and 1 = the next midnight. Use it when times are imported as text and you need to perform arithmetic or comparisons on them.
Excel
=TIMEVALUE(A2)Google Sheets
=TIMEVALUE(A2)Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1Enter times as text strings in a column, e.g. '2:30 PM' or '14:30:00'.
- 2In the adjacent column type =TIMEVALUE(A2) to get the decimal fraction.
- 3Format the result cell as Time or use it in arithmetic such as =TIMEVALUE(A2)*24 to get hours.
Need a version for your data?
Try: “Convert text like '3:45 PM' to a numeric time value I can do math with”