If A1 displays 2:25 and B1 displays 4:55, then the formula =A1+B1 in C1 will
result in 7:20
Actually, Excel thinks you mean 2 hours, 25 mins, 0 seconds so C1 needs to
be formatted the same as A1 and B1 (h:mm)

To be precise you need 0:2:25 and 0:4:55
If hours exceed 24 you need forma [h]:mm:ss

Tell us what you have tried and what problems you have hit on
best wishes

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Liz" wrote in message
...
If I have the time listed to do different jobs in minutes and seconds and
I
want to total them, what formatting do I use?