beautypg.com

Stripduration, 71 stripduration – Apple iWork '09 User Manual

Page 71

background image

Chapter 4

Duration Functions

71

STRIPDURATION

The STRIPDURATION function evaluates a given value and returns either the number
of days represented, if a duration value, or the given value. This function is included for
compatibility with other spreadsheet applications.

STRIPDURATION(any-value)

Â

any-value: A value. any-value can contain any value type.

Usage Notes

If

Â

any-value is a duration value, the result is the same as for DUR2DAYS; otherwise

any-value is returned.
This function may be automatically inserted when a Numbers ’08 document is

Â

upgraded, or an Excel or Appleworks document is imported. It is removed in any
copy of the file saved as a Numbers ’08 or Excel document.

Examples

=STRIPDURATION(”1w”) returns 7, the equivalent of one week in days.
=STRIPDURATION(12) returns 12; since it was not a duration value it is returned.
=STRIPDURATION (”abc”) returns “abc”.

Related Topics
For related functions and additional information, see:

“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