MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Converting seconds (raw number) to minutes (mm:ss format)


Posted by Brian on January 25, 2001 6:47 PM

Perhaps this is a stupid question, but my brain seems to be failing me right now.

Cell A1 contains this number representing the total number of seconds to complete a task: 90

I need cell A2 to convert that number into the minutes:seconds format: 1:30

AND, convert the other direction.

Cell B1 contains this number representing minutes and seconds to complete a task: 1.30

I need cell B2 to convert that number into seconds: 90

Am I missing some simple computations or are there some complex formulas that will make these conversions?

Any help will be greatly appreciated. If this is some simple thing I'm missing, I'll accept the humiliation to get this figured out. Thanks


Posted by cpod on January 25, 2001 7:30 PM


A2 = A1/(24*60) and format as time

If B1 contains the number 1.3 for one minute and 30 seconds then:

B2 = TRUNC(B1)*60 + (B1-TRUNC(B1))*100


Posted by Brian on January 26, 2001 10:28 AM

Well, that was pretty simple. I completely accept the humilitation.

Thank you very much!