How do I to format minutes:seconds into usable format?

  • Thread starter Thread starter Greg
  • Start date Start date
G

Greg

I have an excel column that has minutes:seconds. I cannot
do any calculations because the minutes go over 60. How
do I format these cells, so I can perfom some
calculations. Example might be 129:15 + 222:15=total
time. I also need the average (total/2).
 
Hi
just apply the custom format
[mm]:ss
to the target cell to prevent the rollover after 60 minutes
 
Back
Top