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

  1. The Excel time must be a decimal representation format.
  2. Can be a time value linked to another Excel function or formula.
  3. Can be linked to another cell reference

HOUR Function Usage Examples:

Review the results in column B.

HOUR Function

Common Errors:

#VALUE! error – The given serial_number is not a valid Excel time.