Difference between revisions of "Documentation/How Tos/Calc: SECOND function"
From Apache OpenOffice Wiki
< Documentation | How Tos
m (→Example:) |
(→See also:) |
||
| Line 24: | Line 24: | ||
'''[[Documentation/How_Tos/Calc: HOUR function|HOUR]]''', | '''[[Documentation/How_Tos/Calc: HOUR function|HOUR]]''', | ||
'''[[Documentation/How_Tos/Calc: MINUTE function|MINUTE]]''' | '''[[Documentation/How_Tos/Calc: MINUTE function|MINUTE]]''' | ||
| + | |||
| + | '''[[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: Date & Time functions|Date & Time functions]]''' | ||
| − | '''[[Documentation/How_Tos/Calc: | + | [[Documentation/How_Tos/Calc: Functions listed alphabetically|'''Functions listed alphabetically''']], |
| + | [[Documentation/How_Tos/Calc: Functions listed by category|'''Functions listed by category''']] | ||
Revision as of 07:10, 12 September 2008
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:
YEAR, MONTH, DAY, WEEKDAY, HOUR, MINUTE
Functions listed alphabetically, Functions listed by category
