HOUR Function in Excel

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.

Leave a Reply

DSUM Function

The Dsum function is used to calculate a specified column in a database that correlates with a specified criteria. =DSUM

Read More »

CONCATENATE Function

The Excel CONCATENATE function joins multiple strings into a single string. You can combine up to 30 text items together.

Read More »
Scroll to Top