# Difference between revisions of "Documentation/How Tos/Calc: TIME function"

From Apache OpenOffice Wiki

< Documentation | How Tos

OOoWikiBot (Talk | contribs) m (Robot: Automated text replacement %s) |
m |
||

Line 28: | Line 28: | ||

* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]] | * [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]] | ||

* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}} | * [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}} | ||

− | [[Category: Documentation/Reference/Calc]] | + | [[Category: Documentation/Reference/Calc/Date and Time functions]] |

## Revision as of 06:46, 13 April 2010

## TIME

returns the time, given hours, minutes and seconds.

### Syntax:

**TIME(hours; minutes; seconds)**

- returns the time, expressed as a date-time serial number.
,**hours**and**minutes**are integers.**seconds**

- If
,**hours**and**minutes**are not within range for a valid time, the time will 'roll over', as shown below.**seconds**

### Example:

**TIME(9; 31; 20)**

- returns the time 9:31:20 am (as a date-time serial number).

**TIME(9; 31; 75)**

- returns 9:32:15 am - the time rolls over, as there are only 60 seconds in a minute.