I want to total a column of Hours:minutes values.
If I use a1+A2+A3 etc, it works if I format the cell in which I want the total to appear as [HH]:MM:SS
But if I use the SUM function for a range of cell (much more convenient) I get the answer 00:00:00.
Is there some other function I should be using or is this a bug?
This is to total a series of glider flight durations express as hours and minutes, to get a total number of hours.