HOUR function
Summary
Converts a serial number to an hour
Syntax
HOUR(serial_number)
The HOUR function syntax has the following arguments:
• Serial_number Required. The time that contains the hour you want to find. Times may be entered as text strings within quotation marks (for example, "6:45 PM"), as decimal numbers (for example, 0.78125, which represents 6:45 PM), or as results of other formulas or functions (for example, TIMEVALUE("6:45 PM")).
• Serial_number Required. The time that contains the hour you want to find. Times may be entered as text strings within quotation marks (for example, "6:45 PM"), as decimal numbers (for example, 0.78125, which represents 6:45 PM), or as results of other formulas or functions (for example, TIMEVALUE("6:45 PM")).
Example
=HOUR(A2)
=HOUR(A3)
=HOUR(A4)
=HOUR(A3)
=HOUR(A4)