Difference between revisions of "Documentation/How Tos/Calc: MINUTE function"

From Apache OpenOffice Wiki
Jump to: navigation, search
m (Bot: Adding Category: Documentation)
m (Robot: Automated text replacement %s)
Line 31: Line 31:
 
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]]
 
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]]
 
* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}}
 
* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}}
[[Category: Documentation]]
+
[[Category: Documentation/Reference/Calc]]

Revision as of 09:31, 24 November 2009


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.

Template:Documentation/SeeAlso

Personal tools