HOUR function

HOUR returns the hour for a given time value. The hour is returned as an integer 0 - 23.



number is a time value represented by a decimal for which the hour is to be returned.


=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.