The DUR2WEEKS function converts a duration value to a number of weeks.
DUR2WEEKS(duration)
duration: The length of time (duration value) to be converted.
Examples |
|---|
=DUR2WEEKS(“2w3d2h10m0s5ms”) returns 2.44146826223545. =DUR2WEEKS(“10:0:13:00:05.500”) returns 10.0773900462963. |