DURATIONVALUE
Description
Returns the duration value, based on the specified time value arguments. Each argument is optional but at least one must be provided. Include a comma for any omitted argument.
Syntax
DURATIONVALUE([
weeks
], [
days
], [
hours
], [
minutes
], [
seconds
], [
milliseconds
])
- weeks: The number of weeks.
- days: The number of days.
- hours: The number of hours.
- minutes: The number of minutes.
- seconds: The number of seconds.
- milliseconds: The number of milliseconds.
Example
Formula | Result |
|---|---|
=DURATIONVALUE(1,2,3,4,5,6) | 1w 2d 3h 4m 5s 6ms |
=DURATIONVALUE(,,5) | 5h |
=DURATIONVALUE(0,2,-24) | 1d |