Formulas and Functions
ଏହି କଣ୍ଟ‍୍ରୋଲ୍‌କୁ ପରିବର୍ତ୍ତନ କରିବା ଫଳରେ ଏହି ପୃଷ୍ଠା ସ୍ବୟଂଚାଳିତ ଭାବରେ ଅପ୍‌ଡେଟ୍ ହୋଇଯିବ

STRIPDURATION

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

STRIPDURATION(any-value)

any-value: The value to be tested.

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 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.

Morty Proxy This is a proxified and sanitized view of the page, visit original site.
ସହାୟକ କି?
କ‍୍ୟାରେକ୍ଟର୍ ସୀମା: 250
ସର୍ବାଧିକ କ‍୍ୟାରେକ୍ଟର୍ ସୀମା 250 ଅଟେ।
ଆପଣଙ୍କ ମତାମତ ପାଇଁ ଧନ‍୍ୟବାଦ।
Morty Proxy This is a proxified and sanitized view of the page, visit original site.