Forum Discussion

Paul LaFata's avatar
Paul LaFata
Copper Contributor
Jul 12, 2018

Converting Time to a decimal format

I am trying to convert a time format that looks like this: 

1 + 13

Into a decimal format that looks like this: 

1.22

I am using this formula: =LEFT(P7,1)+RIGHT(P7,2)/60

 

But, it's not giving me the return I expect. 

Excel Online
Formulas and Functions
  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Jul 12, 2018

    Hi Paul,

     

    Are you sure that the time format looks like this 1 + 13 ?

    This is not a proper time format!

     

    However, I've tried your formula, it works just fine, but you need to use the ROUND function as below:

    =ROUND(LEFT(A1,1)+RIGHT(A1,2)/60,2)

     

     

    Regards

    • Paul LaFata's avatar
      Paul LaFata
      Copper Contributor
      Jul 12, 2018

      Thank you, Haytham. I did discover an issue with the actual cell / number format by playing around with the information, and was able to get the formula to work. But, I think your approach is a very good one. Thank you again for your reply. 

       

      All the best,

      Paul

Resources