Related Topics: | ||
Description: Returns the hour as a number between 0 (12:00 A.M.) and 23 (11:00 P.M.).
Syntax: HOUR(Serial_number)
Serial_number is 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")).
Remarks:
Time values are a portion of a date value and represented by a decimal number (for example, 12:00 PM is represented as 0.5 because it is half of a day).
Example:
HOUR("3:30:30 AM") = 3
HOUR("3:30:30 PM") = 15 [the hour using the twenty-four hour system]
HOUR("15:30") = 15 [the hour using the twenty-four hour system]
© 1992-2015. ReliaSoft Corporation. ALL RIGHTS RESERVED.