HOUR function
HOUR returns the hour for a given time value. The hour is returned as an integer 0 - 23.
Syntax
HOUR(number)
number is a time value represented by a decimal for which the hour is to be returned.
Example
=HOUR(NOW()) returns the current hour.
=HOUR(C4) returns 17 if the content of C4 is 17:20:00.
=HOUR(0.5) returns 12 as 0.5 corresponds to 12/30/1899 12:00:00.