Hi All,

My next question relates to adding times together. If I add 3 cells each with 7 hrs 40 mins in each I get an answer of 23 - correct.

Add 4 cells together I get 6:40, whch if I interpolate, is 24 hours + 6 hrs 40 mins also correct.

BUT

if I want to add say 20 cells together the calculation gets worse. Is there a way of getting the correct hours/minutes from Excel?

Rgds,
Dave R