SECOND function
From Apache OpenOffice Wiki
<
Documentation
|
How Tos
Revision as of 13:49, 30 January 2024 by
DiGro
(
Talk
|
contribs
)
(
diff
)
← Older revision
| Latest revision (diff) | Newer revision → (diff)
Jump to:
navigation
,
search
CALC FUNCTIONS
Date & Time Functions
FUNCTIONS
TODAY
NOW
YEAR
MONTH
DAY
WEEKDAY
HOUR
MINUTE
SECOND
DATE
DATEVALUE
TIME
TIMEVALUE
EOMONTH
EDATE
WORKDAY
NETWORKDAYS
DAYS
DAYS360
DAYSINMONTH
DAYSINYEAR
WEEKS
WEEKSINYEAR
WEEKNUM
WEEKNUM_ADD
MONTHS
YEARS
ISLEAPYEAR
EASTERSUNDAY
YEARFRAC
< Previous Page
Next Page >
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
Date & Time overview
Date & Time functions
Functions listed alphabetically
Functions listed by category
Category
:
Documentation/Reference/Calc/Date and Time functions
Views
Page
Discussion
View source
History
Personal tools
Log in
Navigation
Main Page
Recent changes
Download AOO
Documentation
User Forum
Extensions
Templates
Wiki Help
Search
Tools
What links here
Related changes
Special pages
Permanent link
Page information