TOTALSECONDS()

Count of seconds in Duration

Returns the number of seconds (Decimal value) represented by the given duration of time.

Sample usage

TOTALSECONDS("000:00:12") returns 12

TOTALSECONDS("000:15:00") returns 900 (number of seconds in 15 minutes)

TOTALSECONDS("024:00:00") returns 86,400 (number of seconds in 24 hours)

TOTALSECONDS("024:00:00" + "000:15:00" + "000:00:12") returns 87,312; equivalent to TOTALSECONDS(SUM(LIST("024:00:00", "000:15:00", "000:00:12"))). See also: LIST(), SUM()

TOTALSECONDS(TIMENOW() - "00:00:00") returns the number of seconds 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

TOTALSECONDS(duration)

  • duration - A Duration value.

See also

Date and time expressions

HOUR()

MINUTE()

SECOND()

TOTALHOURS()

TOTALMINUTES()

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