The Excel HOUR function returns an integer representing the hour component of a supplied Excel time.
The syntax of the function is:
where the serial_number argument is the time from which you want to extract the hour component. This may be entered to the function as either:
Note that, if the serial_number argument contains a date and time, the Hour function ignores the date part of the argument.
In column B of the following spreadsheet, the Excel Hour function is used to extract the hour from several different supplied times.
Note that, in the above spreadsheet, the time shown in cell A5 is actually a whole day plus the time 05:11:22. Therefore, when supplied with this value, the Hour function ignores the full day and simply returns the hour value 5.
Similarly, the date part of the value in cell A6 is ignored, and the hour function simply returns the hour value 8.
Further information and examples of the Excel Hour function are provided on the Microsoft Office website.
If you get an error from the Excel Hour Function, this is likely to be the #VALUE! error:
|#VALUE!||-||Occurs if the supplied serial_number is not a valid Excel time.|