Documentation/Calc Functions/TIME

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

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


Function name:

TIME

Category:

Date and Time

Summary:

TIME returns the current time value from values for hours, minutes and seconds. This function can be used to convert a time based on these three elements to a decimal time value.

Syntax:

TIME(Hour; Minute; Second)

Returns:

Arguments:

Use an integer to set the Hour.

Use an integer to set the Minute.

Use an integer to set the Second.

Additional details:

Examples:

=TIME(0;0;0) returns 00:00:00

=TIME(4;20;4) returns 04:20:04

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: