Forum

Notifications
Clear all

Converting feet, inches and fractions

4 Posts
2 Users
0 Reactions
169 Views
(@alanr)
Posts: 79
Estimable Member
Topic starter
 

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

 
Posted : 10/03/2021 3:09 pm
(@catalinb)
Posts: 1937
Member Admin
 

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.

 
Posted : 11/03/2021 3:29 am
(@alanr)
Posts: 79
Estimable Member
Topic starter
 

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!

 
Posted : 11/03/2021 11:21 am
(@catalinb)
Posts: 1937
Member Admin
 

You're welcome 🙂

 
Posted : 11/03/2021 1:16 pm
Share: