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

From Apache OpenOffice Wiki

< Documentation | How Tos

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

Line 18: | Line 18: | ||

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

− | + | {{Documentation/SeeAlso| | |

− | + | * [[Documentation/How_Tos/Calc: DATE function|DATE]] | |

− | + | * [[Documentation/How_Tos/Calc: TIMEVALUE function|TIMEVALUE]]''' | |

− | + | * [[Documentation/How_Tos/Calc: Date & Time functions#Date and Time overview|Date & Time overview]]''' | |

− | + | * [[Documentation/How_Tos/Calc: Date & Time functions|Date & Time functions]]''' | |

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

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

## Revision as of 14:23, 25 February 2009

## 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.