Adding hours, minutes, seconds... not time on a clock

[RodneyW]

I had a similar question yesterday that was successfully answered but this is a little different. I'm trying to add hours, minutes, seconds to get a total running time, not time on a clock. The column headlined "Length" is the length of time a specific action requires. It will always be minutes and seconds, never an hour, these items will never exceed 10 minutes. The column titled "Total" should be a running total of the "Length" entries. You can see that once the total exceeds 24, it reverts back to zero as if a new day starts. Where this shows 0:26, I need it to show 24:26 and later when the total is high enough 1:12:42.

Excel 2013. Thanks in advance

 

[Micron]

If your values are entered as 00:01:30 and the cells are first formatted as (custom) [h]:mm:ss then Sum over the range might give you what you need. Using what I think is your values I get 29 minutes and 7 seconds. Maybe I mis-typed (that's why cut and paste is better than pics of data). If the duration exceeds 00:59:59 then you'll get something like 1:05:06

0:01:30	0:29:07
0:02:58
0:03:35
0:03:20
0:03:23
0:05:20
0:04:20
0:00:25
0:02:56
0:01:20