trying to add numbers in a column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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?
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Numbers showing Up Centered in Cell ? 1
Macro to add numbers in a text string 5
Add cells between blank cells 3
Help Writing a SUM Formula 5
Time punch & hours calculations 1
Disable auto (date) format? 3
Sorting Problem 5
Median of column I if column A numbers match 2

Back
Top