Examples

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

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

TOTALSECONDS("024:00:00") : 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 )

Arguments

  • duration (Duration)

Return Value

Number: the number of seconds represented by the given duration of time.

See Also

HOUR(), MINUTE(), SECOND(), TOTALHOURS(), TOTALMINUTES()

Did this answer your question?