TIMEVALUE Function
Turns a time written as text into a real time.
Category
Date & Time
Available in
All versions, Microsoft 365
Returns
A time (fraction of a day)
Want to practice TIMEVALUE in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox
Overview
TIMEVALUE reads text such as "6:45 PM" or "18:45" and returns the time as a fraction of a day, ready to calculate with.
If the text also has a date, the date is ignored.
Syntax
=TIMEVALUE(time_text) Explain
Arguments
| Argument | Required? | What it does |
|---|---|---|
| time_text | Yes | Text that looks like a time, or a cell holding it. |
Examples
Example 1 — Text times from an export
Each returns 0.78125 — 6:45 PM as a fraction of a day. Format as Time to see the clock time.
B2fx=TIMEVALUE("6:45 PM")
| A | B | |
|---|---|---|
| 1 | Text | TIMEVALUE |
| 2 | "6:45 PM" | 0.78125 |
| 3 | "18:45" | 0.78125 |
| 4 | "3/15/2026 6:45 PM" | 0.78125 |
Example 2 — Hours between two text times
Convert both, subtract, then multiply by 24.
=(TIMEVALUE(B2)-TIMEVALUE(A2))*24 Explain
Common mistakes
- #VALUE! on a real time. TIMEVALUE only accepts text. A right-aligned time is already a number — use it directly.
Notes

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.