I copied your data and tried =SUM(A1:A7) and formatted the ** formula cell
alone ** to custom format [h]:mm. It gives me 45:45


If this post helps click Yes
---------------
Jacob Skaria


"brianfar" wrote:

05:20
07:20
07:30
07:30
07:00
05:20
05:45
the above numbers are all individual times eg ( 5 hours and 20 minutes). I
need to add them all, which should come up to 45 hours and 5 minutes. The
format is [h]:mm for more than 24 hours, but the toatl it shows is 93:45
. Can anyone show me which formula to use to add up time. I have tried all
other from different websites(mrexcel.com etc) and have tried all of ther
suggestions, but still am stumped