Count of minutes in Duration
Returns the number of minutes (Decimal
value) represented by the given duration of time.
Sample usage
TOTALMINUTES("000:00:12")
returns 0.2
(number of minutes in 12 seconds)
TOTALMINUTES("000:15:00")
returns 15
TOTALMINUTES("024:00:00")
returns 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)
duration
- ADuration
value.