The Excel HOUR function returns the hour of the day, a number from 0 (12:00 AM) to 23 (11:00 PM). The HOUR function is an Excel date and time function.
serial_number = a number in the date-time code used by Microsoft Excel or text in time format (for example 9:00 AM)
The HOUR function returns the hour of the day, a number from 0 to 23.
In the example above the HOUR function returns the hour of the day for the date in cell C5.
The result returned is 14 because 2:00 PM is the 14th hour of the day.