how do I total a column with hours and minutes? SUM doesnt work

G

Guest

I have 5 rows of figures which are the result of computing hours and minutes
in each row. I want to total this column and used the formula =SUM(d4:d8)
for the target cell and I get zeros as my answer. No warnings or errors. The
target cell of the sum is formatted to time. What am I doing wrong?
 
G

Guest

If d4:d8 contains text (which = 0) then sum(d4:d8) will equal 0.
Rmember that formatting doesn't mean anything if the underlying data is not
what you expect it to be.

HTH,
 
G

Guest

Gary,
Thanks for the response. How do I take these "text" hours and minutes and
make them numeric so I can add them, and then what do I have to do to
convert them back to hours and minutes after the math has been done?
 

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

Adding Hours & Minutes 3
Hours and sum of hours 2
Adding up total hours worked on employee schedule using various criteria 0
Adding Days and Hours 8
How to Sum Time in Hours & Minutes 9
Column total is wrong 5
sum hours and minutes with Excel 2000 9
Calulating hours, minutes and seconds 5

Top