Number to feet and inches

Try this?

http://www.mrexcel.com/archive/Formulas/29790.html

D Waggs said:

I need to convert a number to feet and inches with either one decimal place on the inches or even better the fraction. Thanks!!

Click to expand...

I'm not sure if this is what you're after...not too flexible as far as breaking down fractions

=INT(A1/12)&"' "&MOD(A1,12)&"/12"""

I have a number as a decimal in feet and I want that number in feet and inches with the inches in a fraction. I have a formula for getting the number into a 16th fraction

=IF(MOD(INT(16*(+B4-INT(B4)+0.0312)),16)=0,TEXT(B4,"#"),IF(MOD(INT(16*(+B4-INT(B4)+0.0312)),8)=0,TEXT(B4,"# 0/2"),IF(MOD(INT(16*(+B4-INT(B4)+0.0312)),4)=0,TEXT(B4,"# 0/4"),IF(MOD(INT(16*(+B4-INT(B4)+0.0312)),2)=0,TEXT(B4,"# 0/8"),TEXT(B4,"# 0/16")))))

If I enter the number, say 325.28 into A1, I want 325 to show up in A2 and then 3 3/8 to show up in A3. The formula above will take 3.36 (which is .28*12 and display the 3 3/8), I just need to seperate the decimal from the larger number, multiply it by 12 and apply the formula above all in one cell.

If A1 has your number 325.58, then in A2, put the formula:

=INT(A1)

This gives you 325 feet.

For the inches, try this in cell A3:

=TEXT((A1-A2)*12,IF(INT((A1-A2)*12)=(A1-A2)*12,"0","# 0/"&16/GCD(ROUND(16*((A1-A2)*12-INT((A1-A2)*12)),0),16)))

Note that you must have the Cell A2 filled in as above...

HTH,
Mike.