Documentation/Calc Functions/MINUTE

Function name:
MINUTE

Category:
Date and Time

Summary:
Determines the minutes value from a date expression passed as a date-time serial number or a text string.

Syntax:
MINUTE(DateTime)

Returns:
Returns a positive integer in the range 0 to 59, which is the minutes value of the given date expression.

Arguments:
DateTime is the date expression (in quotation marks) or a date-time serial number, or a reference to the cell containing one of those types, from which the minutes is to be extracted.


 * If DateTime does not contain a valid date expression, then MINUTE reports a #VALUE! error.


 * If DateTime does not contain any time component, then MINUTE returns 0 (time 00:00:00).

Details specific to MINUTE function
The equation for MINUTE is:


 * MINUTE = INT(HourFraction * 60)

where,


 * DayFraction = DateTime – INT(DateTime)


 * HourFraction = (DayFraction * 24) - INT(DayFraction * 24)

Take care to understand the function’s behaviour if you ever need to pass date expressions corresponding to negative date-time serial numbers to MINUTE (these are dates prior to that selected as the base date on the dialog). For example, if you pass a positive date-time serial number with a fractional part of 0.015 to MINUTE, then it will return the value 21. However, if you pass a negative date-time serial number with a fractional part of 0.015 to MINUTE, then it will return the value 38.

Related LibreOffice functions:
DAY

HOUR

MONTH

SECOND

ODF standard:
Section 6.10.12, part 2

Equivalent Excel functions:
MINUTE