Convert Decimal Feet to Feet and Inches

**Surveyour** · 05-18-2011, 01:04 PM

Hello, I am currently working on cut sheets for my current project. I need to take my decimal feet (ie 1.55) and display them as feet and inches (1' 6 5/8") not (1' 6 3/5") i have a formula which is this=INT(F17)&"' "&TEXT(12*(F17-INT(F17)),"# #/#")&CHAR(34), It works but the problem is the fractional inches 6 3/5" i need them to display in 1/8 1/4 1/2 when applicable. Is there something i could add to this formula to make my inches read like a measuring tape (1' 6 5/8") 1/8 1/4 1/2??? I attached the spreedsheet for review thanks!

**NBVC** · 05-18-2011, 01:56 PM

I found something here that may work for you.

Using this formula:

Please Login or Register  to view this content.

You can get closest fractions to the actual numbers in 16ths of an inch....

You can probably work it so it goes to 32nds... or the other way to 8ths...

**daddylonglegs** · 05-18-2011, 02:49 PM

That doesn't give me the right results NBVC, for example it gives this result for 1.55

1' 1 9/16

My suggestion is to round the original amount to the nearest 8th of an inch and then format appropriately. This formula will do that

=INT(MROUND(A1,1/96))&"' "&TEXT(12*MOD(MROUND(A1,1/96),1),"# #/#")&CHAR(34)

That will give the required result for 1.55 and all other results will be rounded to the nearest 8th of an inch....

**NBVC** · 05-18-2011, 03:10 PM

You're right dll. Scratch my suggestion....

**Surveyour** · 05-18-2011, 03:13 PM

thank you both! daddylonglegs your solution worked it is converting to the proper fractional format.

**ppBingo** · 10-17-2013, 12:43 PM

Thank you for this formula for results to the nearest 1/8th of an inch,

I have played around with it and I think i am correct in saying,

to give results to the nearest 1/16th of an inch you can use the following formula:

=INT(MROUND(A1,1/96))&"' "&TEXT(12*MOD(MROUND(A1,1/192),1),"# #/##")&CHAR(34)