by 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:
