Enter the numbers with a 0 for the hour like so...
0:25:16
0:16:39
0:27:41

and use a custom format like so...
[m]:ss

you can them use a normal sum() function (or any arithmetic function) like
so...
=Sum(A1:A3)
or
=A1+A2+A3

and use the same custom format to get a result like...
25:16
16:39
27:41
69:36

"Emily16" wrote:

I need to add a long list of minutes and seconds. (ex. 25:16, 16:39, 27:41)
I have looked at all the functions and cannot find one that works. They all
want to add the times assuming they are hours and minutes or time on a clock.
I want to find a function that would add up the previous example and display
it as 69:36 total minutes and seconds. It seems like one of the problems I
am running into is finding or creating my own function that knows to add up
the seconds to 60, not 100 like most decimal functions are used to. Does
anyone have an answer? I would be forever grateful!