HOUR function

From Apache OpenOffice Wiki
Jump to: navigation, search
< {{#switch:Previous Section Previous Section = Previous Section Next Section = Next Section Previous Page = Previous Page Next Page = Next Page }} {{#switch:Next Section Previous Section = Previous Section Next Section = Next Section Previous Page = Previous Page Next Page = Next Page }} >
< {{#switch:Previous Page Previous Section = Previous Section Next Section = Next Section Previous Page = Previous Page Next Page = Next Page }} {{#switch:Next Page Previous Section = Previous Section Next Section = Next Section Previous Page = Previous Page Next Page = Next Page }} >



HOUR

Returns the hour of a given time.

Syntax:

HOUR(time)

returns the hour of time as a number, 0 - 23.
time may be text or a date-time serial number.

Example:

HOUR("2008-01-06 21:30:15")

returns 21.

HOUR(A1)

where cell A1 contains the time 9:25:10 as a date-time serial number, returns 9.



{{#switch:EN

| RU = Смотрите также: | UA = Дивіться також: | EN = See Also | PT = Ver também | #default = See Also }}

Personal tools