trying to add numbers in a column

S

Sari

I'm trying to add the numbers in a column. The numbers are in h:mm:ss
format. When I use the function =SUM(I2:I154) It returns a 0. Any help
would be great! thanks!
 
G

Gordon

Sari said:
I'm trying to add the numbers in a column. The numbers are in h:mm:ss
format. When I use the function =SUM(I2:I154) It returns a 0. Any
help would be great! thanks!
Click to expand...

Works for me....what version of Excel?
 
J

JK

The cell in which you have the =SUM(I2:I154) formula should have the format
[h]:mm:ss - it will then show the elapsed time as the result. Or if you
change the format of this one cell to 'General' then you should change the
formula to =SUM(I2:I154)*24 which will then show you the number of hours in
fraction form (for example if the sum of cells I2:I154 is 30 hours and 30
minutes, it will show 30.5 as the result).

Hope this helps.
 
Top