beautypg.com

Dur2days, Dur2hours, 65 dur2days 65 dur2hours – Apple iWork '09 User Manual

Page 65

background image

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.