I have a column of data in the form of minutes and seconds:
ex: 424:06.0 (424 minutes and 6.0 seconds).
I would like to add the rows to give me a total number of minutes and seconds.
Whenever I choose the regular sum function the calculation will not work. I believe that Excel is seeing the data as time on a 24 hour clock and not minutes and seconds.
Can you help?
ex: 424:06.0 (424 minutes and 6.0 seconds).
I would like to add the rows to give me a total number of minutes and seconds.
Whenever I choose the regular sum function the calculation will not work. I believe that Excel is seeing the data as time on a 24 hour clock and not minutes and seconds.
Can you help?