Excel like a finance pro.
← The libraryPractice · 2 questions →
Date function
TIMEVALUE
Converts a time written as text into a time value.
OccasionalDifficulty 1100 · ProficientUsage rank #185 of 520
When to use it
Converts a time written as text into a time fraction.
The shape of it
- Syntax
=TIMEVALUE(time_text)
Worked examples
12-hour text
=TIMEVALUE("6:45 PM") → 0.78125
Format as time to see 6:45 PM.
24-hour text
=TIMEVALUE("18:45") → 0.78125
24-hour text.
Text with a date
=TIMEVALUE("3/15/2025 6:45 PM") → 0.78125
The date part is ignored.
Worth knowing
- Text times from exports are the common source; check for left alignment.
- Multiply by 24 for decimal hours.
- VALUE handles both date and time parts.
Where it goes wrong
- #VALUE! for text it cannot parse, such as "6.45 PM".
- Seconds beyond 59 or hours beyond 23 return #VALUE! where TIME would wrap.
Related
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.