STRIPDURATION(any-value)
any-value: The value to be tested.
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 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, because 12 is not a duration value.
=STRIPDURATION("abc") returns "abc", because "abc" is not a duration value.