Forum Discussion
Excel: accumulate time and display it in hours plus fraction of an hour
I would like to accumulate time and display it in hours plus fraction of an hour, e.g. 11:30 + 9:15 + 6:45 = 26.5 hours
an excellent and thoughtful reply; thanks.
I now have one other request: i want to enter the beginning time as "3000.0" (flying hours) but cannot find the format which lets me do that.
Can you tell me?
(Eg. i would like to add a flight (of say 1:46) to the prior accumulated 3000.0 hours, and express this as "3001.8".)
