Formulas and Functions

DUR2SECONDS
The DUR2SECONDS function converts a duration value to a number of seconds.
DUR2SECONDS(duration)
 duration: The length of time to be converted. duration is a duration value.
Examples
=DUR2SECONDS(”2w 3d 2h 10m 0s 5ms”) returns 1476600.005.
=DUR2SECONDS(”10:0:13:00:05.500”) returns 6094805.5.
Related Topics
For related functions and additional information, see:
“DUR2DAYS” on page 65
“DUR2HOURS” on page 65
“DUR2MILLISECONDS” on page 66
“DUR2MINUTES” on page 67
“DUR2WEEKS” on page 69
“Listing of Duration Functions” on page 64
“Value Types” on page 36
“The Elements of Formulas” on page 15
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41
68 Chapter 4 Duration Functions