adding times together

[changetires]

I have a batch process and each batch has different cycles. Some of
these cycles have different times in which a reaction occurs. What I
want to do is just have a cell add all these times together for a total
hours but how do I get excel to do this using the hh:mm format cause its
having trouble adding the hours if the total number of hours goes past
24 hours.

tks,

Ed

8:00 0:00 4:00 6:00 0:00 2:00 12:00 0:00

add these together with a total at the end

 

[Guest]

Format the cell as [h]:mm

 

[changetires]

That returned a result of 80:00 when it should have been 32:00

tks,

Ed

 

[Dave Peterson]

Try formatting all those cells as: [h]:mm

I'm betting that you'll see that the data isn't what you think it is.

 

[changetires]

Dave,

Thanks for the hint, that is all that was needed, I did identify on
cell that was not formatted like the others. Found it and changed i
to [h]:mm and then in my sumation cell I used the same and it worke
like a champ.

tks,

E