HOUR Function

The HOUR function is one of the date and time functions. It returns the hour (a number from 0 to 23) of the time value.

Syntax

HOUR(serial_number)

The HOUR function has the following argument:

Argument	Description
serial_number	The time value that contains the hour you want to find.

Notes

The serial_number may be expressed as a string value (e.g. "13:39"), a decimal number (e.g. 0.56 corresponds to 13:26) , or the result of a formula (e.g. the result of the NOW function in the default format - 9/26/12 13:39)

How to apply the HOUR function.

Examples

The figure below displays the result returned by the HOUR function.