HOUR

See also A-Z Spreadsheet Function List

Description Returns the hour component of the specified time in 24-hour format.

Syntax HOUR(serial_number)

serial_number is the time as a serial number. The decimal portion of the number represents time as a fraction of the day.

Remarks The result is an integer ranging from 0 (12:00 AM) to 23 (11:00 PM).

See Also DAY , MINUTE , MONTH , NOW , SECOND , WEEKDAY , and YEAR functions

Examples HOUR(34259.4) returns 9

         HOUR(34619.976) returns 23