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)