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:- A decimal (serial number) representation of an Excel time
- A text representation of a time
- A reference to a cell containing a time
- 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)

**Result**: