beautypg.com

Dur2weeks, 69 dur2weeks – Apple iWork '09 User Manual

Page 69

background image

Chapter 4

Duration Functions

69

DUR2WEEKS

The DUR2WEEKS function converts a duration value to a number of weeks.

DUR2WEEKS(duration)

Â

duration: The length of time to be converted. duration is a duration value.

Examples

=DUR2WEEKS(”2w 3d 2h 10m 0s 5ms”) returns 2.44146826223545.
=DUR2WEEKS(”10:0:13:00:05.500”) returns 10.0773900462963.

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

“DUR2SECONDS” on page 68

“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