Excel HOUR function

Function              HOUR

Description        Excel HOUR function returns the hour of a time value. The hour is given as an integer, ranging from 0 (12:00 A.M.) to 23 (11:00 P.M.).

Syntax  HOUR(serial_number)

serial_number It
is value in excel time format