hour

Previous chapterNext chapter Show allShow all    Hide allHide all

The function hour (time) calculates the hour from a time value.

Syntax: =hour(time)

Result format: integer

Example Example

=now() with format string "hh:mm:ss dd/mm/yy" is 12:46:24 05.06.01
Cell A2= day(A1) is 12