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

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).
 
F

Frank Kabel

Hi
just apply the custom format
[mm]:ss
to the target cell to prevent the rollover after 60 minutes
 

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 to find the average duration from these values? 2
How to get the Time Duration out of this feed? 1
Adding Minutes & Seconds expressing time differnce if total is over an hour 2
how do i convert data with miliseconds to just h:mm:ss 5
Change General Format to Currency Format 3
Function to uniformerly format different phone numbers 7
Refusing to Date Format 1
Converting Minutes and Seconds ([mm]:ss) to Decimal 6

Top