Stripduration, 71 stripduration – Apple iWork '09 User Manual
Page 71

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