Examples
TOTALMINUTES("000:00:12")
: 0.2 (number of minutes in 12 seconds)
TOTALMINUTES("000:15:00")
: 15
TOTALMINUTES("024:00:00")
: 1440 (number of minutes in 24 hours)
TOTALMINUTES("024:00:00" + "000:15:00" + "000:00:12")
returns 1455.2; equivalent to TOTALMINUTES(SUM(LIST("024:00:00", "000:15:00", "000:00:12")))
. See also: LIST(), SUM().
TOTALMINUTES(TIMENOW() - "00:00:00")
returns the number of minutes that have passed from midnight today to now. TIMENOW() returns the current Time; subtracting one Time value ("00:00:00"
) from another gives the needed Duration argument. See also: TIMENOW(), Date and Time Expressions.
Syntax
TOTALMINUTES( duration )
Arguments
- duration (Duration)
Return Value
Decimal: the number of minutes represented by the given duration of time.