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
Print/export
Create a book
Download as PDF
Printable version
Search
Tools
What links here
Related changes
Special pages
Permanent link
Page information