HOUR

Returns the hour of a time value. The hour is given as an integer, ranging from 0 (12:00 A.M.) to 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")).
Remark
Microsoft Excel for Windows and Excel for the Macintosh use different date systems as their defaults. 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
The example may be easier to understand if you copy it to a blank worksheet.

	A
1	Time
2	3:30:30 AM
3	3:30:30 PM
4	15:30

Formula	Description (Result)
=HOUR(A2)	Hour of first time (3)
=HOUR(A3)	Hour of second time (15)
=HOUR(A4)	Hour of third time (15)

Related Posts :