Formulas and Functions
ഈ കൺട്രോളിൽ മാറ്റം വരുത്തുന്നത് ഈ പേജ് ഒട്ടോമാറ്റിക്കായി അപ്ഡേറ്റ് ചെയ്യാനിടയാക്കും

DURATION

The DURATION function combines separate values for weeks, days, hours, minutes, seconds and milliseconds, and returns a duration value. Each argument is a number value and at least one argument is required.

DURATION(weeks, days, hours, minutes, seconds, milliseconds)

weeks: An optional value representing the number of weeks.

days: An optional value representing the number of days.

hours: An optional value representing the number of hours.

minutes: An optional value representing the number of minutes.

seconds: An optional value representing the number of seconds.

milliseconds: An optional value representing the number of milliseconds.

Notes

  • An argument that is 0 can be omitted, but the comma must be included if later values are included. For example, =DURATION(,,12,3) would return a duration value of 12h 3m (12 hours and 3 minutes).

  • Negative values are permitted. For example, =DURATION(0,2,-24) would return a duration of 1 day (2 days minus 24 hours).

Examples

=DURATION(1) returns 1w (1 week).

=DURATION(,,1) returns 1h (1 hour).

=DURATION(1.5) returns 1w 3d 12h (1 week, 3 days, 12 hours or 1.5 weeks).

=DURATION(3,2,7,10,15.3505) returns 3w 2d 7h 10m 15s 350ms (3 weeks, 2 days, 7 hours, 10 minutes, 15 seconds, 350 milliseconds).

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.