HOUR


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

Syntax HOUR ( serial_number )

Argument Description
serial_number 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).

Examples This function returns 9:

HOUR(34259.4)

This function returns 23:

HOUR(34619.976)

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