Documentation/How Tos/Calc: MINUTE function

CALC FUNCTIONS

Date & Time Functions

< Previous Section

Next Section >

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 >

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