The HOUR function in Excel returns the hour component of a specified time as a number between 0-23. Make sure you review the usage notes and understand how to correct #value error message.
Syntax:
=HOUR(serial_number)
Arguments
- serial_number – (required) Time that contains the hour. Excel will return an integer between 0 to 23.
- 0 = 12:00 AM
- 23 = 11:00 PM
Usage Notes
- The Excel time must be a decimal representation format.
- Can be a time value linked to another Excel function or formula.
- Can be linked to another cell reference
HOUR Function Usage Examples:
Review the results in column B.
Common Errors:
#VALUE! error – The given serial_number is not a valid Excel time.