SECOND 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.
SECOND
Returns the seconds of a given time.
Syntax:
SECOND(time)
- returns the seconds of time as a number, 0 - 59.
- time may be text or a date-time serial number.
Example:
SECOND("2008-01-06 21:30:15")
- returns 15.
SECOND(A1)
- where cell A1 contains the time 9:25:10 as a date-time serial number, returns 10.
See Also
