Documentation/How Tos/Calc: MINUTE function
From Apache OpenOffice Wiki
<
Documentation
|
How Tos
Revision as of 07:29, 17 July 2018 by
Sancho
(
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 >
Contents
1
MINUTE
1.1
Syntax:
1.2
Example:
MINUTE
Returns the minutes of a given time.
Syntax:
MINUTE(time)
returns the minutes of
time
as a number,
0
-
59
.
time
may be text or a date-time serial number.
Example:
MINUTE("2008-01-06 21:30:15")
returns
30
.
MINUTE(A1)
where cell A1 contains the time
9:25:10
as a date-time serial number, returns
25
.
See Also
YEAR
MONTH
DAY
WEEKDAY
HOUR
SECOND
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