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
- ADuration
value.