Format cells as [h]:mm and the SUM as normal.

"hadleigh" wrote:

I'm trying to add increments of time (in the h:mm format, for example 3:15),
to come up with the total hours and minutes in part of a column, in Excel
2002. I've tried the =SUM(cell:cell) and the =SUM(cell:cell)*24 formats and
neither works properly. I've tried adjusting the format of the cell with the
formula in it. Still not working. Can anyone help? Thanks.