The DUR2DAYS function converts a duration value to a number of days.
DUR2DAYS(duration)
duration: The length of time (duration value) to be converted.
Examples |
|---|
=DUR2DAYS(“2w3d2h10m0s5ms”) returns 17.09027784. =DUR2DAYS(“10:0:13:00:05.500”) returns 70.54173032. |