How it works
Add the hours to minutes divided by 60 and seconds divided by 3,600. Enter the duration as HH:MM or HH:MM:SS.
Worked example
Use Duration as HH:MM:SS 02:30:00. The result is 2.5 hours.
Convert hours and minutes from a clock-style duration into decimal hours.
Add the hours to minutes divided by 60 and seconds divided by 3,600. Enter the duration as HH:MM or HH:MM:SS.
Use Duration as HH:MM:SS 02:30:00. The result is 2.5 hours.