DateLevel: BeginnerAvailable in: Excel 2007+
In this article
- Syntax
- Examples
- Example 1
- Related functions
HOUR returns 0–23 from a time or date-time. The quickest way to group call-centre or sales data by hour of day.
Syntax
=HOUR(serial_number)
| Argument |
What it means |
serial_number |
Time or date-time. |
Examples
Example 1
=COUNTIFS(Calls!C:C, ">="&TIME(H2,0,0))
Pair with a helper =HOUR(C2) column and a pivot for calls per hour.
💡 HOUR never goes past 23. For durations over a day use =INT(A2*24).
MINUTE · SECOND · TIME
📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.
✨ Ask AI about this articleStuck on a step? Ask a question and the AI answers using this article.
Free · AI can be wrong