Description
Used to return the hour as a number from a given time. This function is used in situations where we need to work on hours from the provided time in Excel.
=HOUR(serial_number)
The HOUR function syntax has the following argument:
- Serial_Number Required.
The time that contains the hour you want to find.
Times may be entered as results of other formulas or functions (for example, TIMEVALUE(“6:45 PM”)), as decimal numbers (for example, 0.78125, which represents 6:45 PM), or as text strings within quotation marks (for example, “6:45 PM”).
