Formulas and Functions

Chapter 4 Duration Functions 65
DUR2DAYS
The DUR2DAYS function converts a duration value to a number of days.
DUR2DAYS(duration)
 duration: The length of time to be converted. duration is a duration value.
Examples
=DUR2DAYS(”2w 3d 2h 10m 0s 5ms”) returns 17.09027784.
=DUR2DAYS(”10:0:13:00:05.500”) returns 70.5417302.
Related Topics
For related functions and additional information, see:
“DUR2HOURS” on page 65
“DUR2MILLISECONDS” on page 66
“DUR2MINUTES” on page 67
“DUR2SECONDS” on page 68
“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
DUR2HOURS
The DUR2HOURS function converts a duration value to a number of hours.
DUR2HOURS(duration)
 duration: The length of time to be converted. duration is a duration value.
Examples
=DUR2HOURS(”2w 3d 2h 10m 0s 5ms”) returns 410.1666681.
=DUR2HOURS(”10:0:13:00:05.500”) returns 1693.001528.