The DUR2HOURS function converts a duration value to a number of hours.
DUR2HOURS(duration)
duration: The length of time (duration value) to be converted.
Examples |
|---|
=DUR2HOURS(“2w3d2h10m0s5ms”) returns 410.1666681. =DUR2HOURS(“10:0:13:00:05.500”) returns 1,693.001528. |