how do I add minutes and seconds together in excel

G

Guest

Can someone please tell me how to set up a formula so that I can add time
units together e.g 6minutes and 32 seconds + 5 minutes and 48 seconds to get
a result of total minutes and seconds
 
R

Ragdyer

What format are they in now?

If you're using XL recognized time formats, just add the cells together
=Sum(A1:A5)
and format the totaling cell to
[mm]:ss
to prevent the minutes from rolling over into hours.

Does this help?

Or, are you using text strings, similar to what you actually posted in your
question?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I sum increments of minutes and seconds 5
dispay numbers as minutes and seconds in excel 2
Convert Seconds to Minutes 11
How do I change a minutes and seconds as a 2400 time to seconds? 1
Cumulative time calculation in Excel 2003 2
sum total of hours minutes seconds in excel 2003 2
Calculating and Adding Hours, Minutes, and Seconds in a CALL LOG 1
getting excel to recognise copied data as mm:ss not hh:mm 2

Top