Date
HOUR
Definition
HOUR returns the hour of a time, from 0 to 23.
Syntax
=HOUR(serial_number)
Arguments
| Argument | Meaning |
|---|---|
serial_number |
A time, or the cell holding it. |
Worked example
A ferry log stores departure times. Times are in A2:A4.
| A: Depart |
|---|
| 14:45 |
| 7:10 |
| 23:05 |
Formula: =HOUR(A2)
Result: 14. 14:45 falls in hour 14. Filled down, the formula gives 14, 7, and 23.
Practice
Cell A2 holds 9:30. In B2, write a formula that returns the hour of that time.
- In B2, write an HOUR formula for A2.
- B2 should show the hour of A2.
Step 1 of 2
Enter =HOUR(A2) in B2.
A2 is 9:30, so the hour is 9.
Formulas here use English function names, such as SUM, and a period as the decimal separator, in every language.
Loading the sheet…
B2 uses HOUR.
B2 now shows 9.
Related functions
TIME builds the clock value HOUR reads. TODAY is a date at midnight, so HOUR of TODAY is 0.
Common mistake
Reading a 2:30 pm cell as 2: HOUR uses a 0-23 clock, so 14:30 returns 14.