HOUR

Returns the hour (0 through 23) from a time.

Syntax

HOUR( time )

time
format: h:m a

h (required) - An integer between 0 and 23 representing hour of the day.
m (required) - An integer between 0 and 59 reprsenting minute of an hour.
a (optional) - A string either "am" or "pm" if using an integer between 1 and 12 for hour of the day. 

Examples