Table of Contents
Summary
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.
Function
=HOUR(serial_number)
Arguments (inputs)
serial_number = a number in the date-time code used by Microsoft Excel or text in time format (for example 9:00 AM)
Return value
The HOUR function returns the hour of the day, a number from 0 to 23.
Example
In the example above the HOUR function returns the hour of the day for the date in cell C5.
=HOUR(C5)
The result returned is 14 because 2:00 PM is the 14th hour of the day.
