HOUR
Category: DateTime Function.
Description: Returns an integer that is the hour component of a specified time.
Syntax: HOUR(time)
Time can be a text string representing time, the result of other functions (such as TIMEVALUE), or a decimal number.
The decimal number is calculated as a portion of a date value (24 hours is 1.0, so 3 AM is 0.125 in decimal time).