Hi there,
I am trying to figure out if there is a formula that would allow me to convert feet, inches and fractions in one string to a decimal value. For example "47 2 3/4", that is 47 feet, 2 and 3/4". I found a formula that converts the "2 3/4" part of the string but when I add in the "47" it errors out. I realize I could easily parse out the 47 and convert the 2 3/4 but ideally I'd like a formula that converts the whole string.
The workbook attached has the formula I am working with, it is working in cell B4 it is not working in cell B3. If someone has a solution that would be great.
Alan
Hi Alan,
I see that you have formatted column A as fraction, but this format can handle inches, not feet.
In this case, you can type column A values as: =47*12 +2 1/4 (convert feet to inches), will show up in the cell as 566 1/4
This way, you don't need any conversion, column A contains numbers displayed as a fraction. For example, your formula from cell B4 can be replaced with: =A4, with cell B4 formatted as number or General.
Hi Catalin, great to hear from you again! I am still using the query you helped me with every day 🙂
Your answer here worked a treat, thanks again and stay safe!
You're welcome 🙂