Documentation/Calc Functions/HOUR

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

Under construction.
For now, see the system Help files.


Function name:

HOUR

Category:

Date and Time

Summary:

Returns the hour for a given time value.

Syntax:

HOUR(Number)

Returns:

The hour is returned as an integer between 0 and 23.

Arguments:

Number, as a time value, is a decimal, for which the hour is to be returned.

Additional details:

Examples:

=HOUR(NOW()) returns the current hour

=HOUR(C4) returns 17 if the contents of C4 = 17:20:00.

Related LibreOffice functions:

DAY
MINUTE
MONTH
NOW
WEEKDAY
YEAR

ODF standard:

Equivalent Excel functions: