HOUR function

HOUR(date) HOUR(date)

date — Number or { Number }

The date to be converted, as a sequential serial number.

Returns — Number or { Number }

The hour of the date (0 through 23).

Converts a date to a number representing the hour of the date.

Example

HOUR(TIME(1, 25, 2))HOUR(TIME(1; 25; 2))

Returns 1, the hour of the time 1:25:02 (2:25 PM).