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?

Need more help?

Try these next steps:

true
Search
Clear search
Close search
Google apps
Main menu
730716285307703350
true
Search Help Center
true
true
true
false
false