Formulas and Functions

DUR2SECONDS
The DUR2SECONDS function converts a duration value to a number of seconds.
DUR2SECONDS(duration)
duration: The length of time (duration value) to be converted.
Examples |
---|
=DUR2SECONDS("2w3d2h10m0s5ms") returns 1,476,600.005. =DUR2SECONDS("10:0:13:00:05.500") returns 6,094,805.5. |