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?

Need more help?

Try these next steps:

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