MINUTE function

From Apache OpenOffice Wiki
Jump to: navigation, search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.



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

Personal tools