For example my current format cell is mm:ss

00:01

01:23

10:34

How do I do the sum? what is the formula?

sorry mmcconaghy, but your answer contains some error, because seconds sum up to 60 before changing in minutes.

sorry mmcconaghy, but your answer contains some errorI don't think so.

10:34 + 1:23 = 11:57

11:57 + 0:01 = 11:58

I think you should read up on how to do time math:http://www.cpearson.com/excel/datet...

MIKE

Ask Your Question

Weekly Poll