TOTALMINUTES()

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 - A Duration value.

See also

Date and time expressions

HOUR()

MINUTE()

SECOND()

TOTALHOURS()

TOTALSECONDS()

Was this helpful?
How can we improve it?
Search
Clear search
Close search
Google apps
Main menu
Search Help Center
false
false