Excel like a finance pro.
← The libraryPractice · 2 questions →
Date function
HOUR
Returns the hour from a time.
CommonDifficulty 950 · CapableUsage rank #154 of 520
When to use it
The hour, 0 to 23, from a time.
The shape of it
- Syntax
=HOUR(serial_number)
Worked examples
Hour of a time
=HOUR(TIME(18,45,30)) → 18
Six in the evening.
Business-hours flag
=HOUR(A1)>=9 → TRUE
A1 is 6:45 PM: an after-opening test.
Elapsed whole hours
=HOUR(B1-A1) → 2
Whole hours between 9:30 and 11:45; drops the minutes.
Worth knowing
- Decimal hours from a duration: =(B1-A1)*24, not HOUR.
- Group timestamps by hour for a heatmap.
- Works on date-times; the date is ignored.
Where it goes wrong
- Durations over 24 hours wrap: HOUR of 26 hours is 2.
- Text times return #VALUE!.
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.