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

ArgumentRequired?What it does
time_textYesText 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")
AB
1TextTIMEVALUE
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

Kyle Stott

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.