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
A1 - 11:30
A2 - 9:15
A3 - 6:45
In cell A4, enter the formula: =A1+A2+A3
A2 - 9:15
A3 - 6:45
In cell A4, enter the formula: =A1+A2+A3