How to use Excel HOUR Function


HOUR function in Excel is a type of DATE/TIME function. This function is used to find hours from a given time. It gives result in form of numbers ranging from 0(12:00 AM) to 23(11:00 PM). For example, for time 10:15 AM, HOUR function will retrieve 10. HOUR function can also be used with the TIME function for feeding hours into this function.




Serial_Number- This is time in a valid excel format.


  • Time values are represented in form of decimal numbers, for example 6:00 PM is represented by 0.75 as it is 0.75 of 24 hours which is 18 hours.
  • Time can be entered in form of text strings or decimal numbers; to reduce errors, TIME function can be used to supply time.
  • Excel default format for storing date and time is in form of serial numbers; to view it in readable form, use formatting tab.


In this example, Time is given in column A and Hour function is used in column B to extract number of hours from the time.

Leave a Comment

Your email address will not be published. Required fields are marked *