June 18, 2021

How to use the Excel HOUR function

To split hours from a time value as a time, minutes, or a date with a time such as “4/10/2020 11:40” You use the HOUR function in Excel, it helps you split hours easily. Easy with simple syntax. In addition, you can combine with various functions to perform the calculation.

Syntax: = HOUR(serial_number)

The AND function syntax has the following arguments:

  • Serial_number (required argument) – The time that contains the hour we want to find. It will return the hour of the time value. The hour given will be an integer between 0 to 23 where 0 represents 12:00 AM and 23 represents 11:00 PM.The argument can be entered as:
    1. A decimal (serial number) representation of an Excel time
    2. A text representation of a time
    3. A reference to a cell containing a time
    4. A time value returned from another Excel function or formula

Example: Let’s see how this function work when we have provided the following inputs

Syntax:  =HOUR(A2)


Excel HOUR function - How to use the Excel HOUR function

READ:  How to use the Excel CONCATENATE function

Leave a Reply

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