Decimal to Feet/Inches (tape measure friendly)

[Capsaicin Burn]

My goal is to calculate the diagonal measurement, in feet and inches, needed to square a building based on depth and width of the building.

My formula is A= building depth in ft. and B= building width in ft.
So A squared + B squared = C squared

Calculate the square root of C squared (ft.) and that is my diagonal number to square the building with.

All of that I have conquered. Now the number I receive is a decimal number which is often followed by many decimal digits.

How do I take that number and convert it to feet and inches that is tape measure friendly.

A random example is:
38.4' = 38' 4 4/5" (based on my excel conversion technique)

I guess I need the 4 4/5" converted to a tape measure friendly number. Sometimes the fractions giving are three digit numbers.

Maybe I can't figure it out because I'm making it more difficult than it needs to be. Thanks for ANY help.

 

[rpaulson]

Format the cell as fraction using 16th's.

 

[SpillerBD]

Pretty tape measure friendly...
However,

=MROUND(MOD(A1,1)*12,1/16)

and then format to fraction, up to two digits. Gives you 1/8 instead of 2/16 etc.

 

[Capsaicin Burn]

Thanks very much. It worked!

SpillerBD's did as well when applied in a different way.