how to sum up mm:ss in excel column into 1 cell?

(As I put here: https://stackoverflow.com/a/69232281/16941696)

Between your question and your comments, I couldn't figure out if you are trying to count hours and minutes, or minutes and seconds. The solution works in either case.

I drafted an explanation with both possibilities, just in case. (Unfortunately, I don't have enough rep to post images, so that's the link to the image.)


Here's an explanation if you can't get to the image for whatever reason:

By default when you SUM time in Excel, it counts time of day + time of day. For instance, 9:00 AM + 11:00 AM would be displayed as 8:00 PM.

What we want is to count AMOUNT of time. In that case 9:00 + 11:00 would be displayed as 20:00.

When counting minutes and seconds, enter the info as 00:mm:ss and format it as mm:ss. In the cell you calculate the SUM in, format it as [mm]:ss to count AMOUNT of time rather than TIME itself.

When counting hours and minutes, enter the info as hh:mm:00 and format it as hh:mm. In the cell you calculate the SUM in, format it as [hh]:mm to count AMOUNT of time rather than TIME itself.

If you wanted, you could also count days.

dd "days" hh "hours and" mm "minutes"