Convert Mm:ss To Decimal Minutes

  • I have a group of numbers that I need to convert from mm:ss formatting to decimal minute format such as 10 minutes 30 seconds (10:30 to 10.50) or (08:22 to 08.366). I have read the threads that show how to convert decimal minutes to seconds but I wasn't able to convert around to the solution I need.


    Thanks for your valuable time.

  • Re: Convert Mm:ss To Decimal Minutes


    ah, your answer is shown above ANSWERS TO SIMLIAR QUESTIONS
    but I will attach the link that has the answer, JIC Convert Minutes to Decimals



    =A1*24 and format as General or required decimal format

    Thanks,
    David
    [size=-2]Bad news. These are the good old days.[/size]

  • Re: Convert Mm:ss To Decimal Minutes


    Thanks dcraker, I had tried that formula and it didn't work but when I got your reply I tried again and still no luck so I started looking at the format of the cells I was trying to convert and found that was my problem, once I retyped in the mm:ss it worked as it should.
    Thank you for the reply and for forcing me to look deeper for the problem.

  • Re: Convert Mm:ss To Decimal Minutes


    sorry, I put in the wrong information that would have confused people more than necessary



    good that you figured it out.
    What did your end results look like anyways?

    Thanks,
    David
    [size=-2]Bad news. These are the good old days.[/size]

  • Re: Convert Mm:ss To Decimal Minutes


    Once I corrected the cells that had been imported (2:15) to (02:15) the formula worked as stated - 2.25. I'm really not sure why I had to re-type the cells in but once I did I got the desired results.
    Thanks again.
    Chuck

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!