DUR2DAYS
Description
Returns the number of days, based on the specified duration.
Syntax
DUR2DAYS(
duration
)
- duration: The time value to convert. Examples: 1w2d3h4m5s6ms or 11:2:33:05:05.600.
Example
Formula | Result |
|---|---|
=DUR2DAYS("1w2d3h4m5s6ms") | 9.127835718 |
=DUR2DAYS("11:2:33:05:05.600") | 80.378537037 |