HOUR

Returns the hour component of a time as a whole number, so =HOUR(E5) on 9:45:22 gives 9. Its cell uses the General format, not a time format.

When to use

Part of the group of functions (with MINUTE and SECOND) that take a time value apart, shown in the Time Functions sheet.

See Lec 05.

Appears in

No references yet.