Description
Returns the hour component of the specified time in 24-hour format.
Syntax
HOUR ( serial_number )
| Parameter | Description |
|---|---|
| serial_number | The time as a serial number. The decimal portion of the number represents time as a fraction of the day. |
Remarks
The result is an integer ranging from 0 (12:00 AM) to 23 (11:00 PM).
Examples
This function returns 9:
HOUR(34259.4)
This function returns 23:
HOUR(34619.976)
See also