Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

How to sum a column of hours:minutes values

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.