TIME function
From Apache OpenOffice Wiki
< Documentation | How Tos
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
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, minutes and seconds are integers.
- If hours, minutes and seconds are not within range for a valid time, the time will 'roll over', as shown below.
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.
See Also
