April 23, 2015
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
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
November 8, 2013
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.
Answers Post
1 Guest(s)