HOUR
Description
Returns an integer from 0 to 23 representing only the hour (12:00 AM to 11:00 PM, respectively) specified in the time.
Syntax
HOUR(
date
)
- date: The time to get the hour value from. You can enter the time as a serial number, text, a cell reference, or a value returned from another formula.
Example
Formula | Result |
|---|---|
=HOUR("16:15:14") | 16 |
=HOUR("5:35 PM") | 17 |
=HOUR("11/1/2017 6:31 PM") | 8 |