The HOUR function
Returns the hour of a time as a number from 0 to 23. Times are fractions of a day, so 0.75 is 6:00 PM and HOUR(0.75) is 18.
Syntax
HOUR(serial_number)- serial_number
- The time, or date and time, to take the hour from.
Examples
B1=HOUR(TIME(14,30,0))
| A | B | |
|---|---|---|
| 1 | 14 |
B1=HOUR(0.75)
| A | B | |
|---|---|---|
| 1 | 18 |
B1=HOUR("9:45 PM")
| A | B | |
|---|---|---|
| 1 | 21 |
Questions
How do I get the minutes and seconds of a time?
MINUTE and SECOND work just like HOUR, so =MINUTE(A2) returns 0 to 59.
How do I turn a time into decimal hours?
Multiply by 24, as in =A2*24, and format the cell as a number. 2:30 becomes 2.5.