TOTALSECONDS()

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()