Measurement conversion in G-Sheets

[Contech]

I hope its ok to post questions about google sheets...

I have the following problem:
I need the following formula to convert into FEET" & INCHES" only.

For example, my formula right has 13.8750(13' 7/8") converting to 166.5 INCHES. This conversion is correct but now what I need it for.

I need it to convert to 156 7/8" (156.8750) i just don't know how to adjust it. So basically i need it to read the 13 as FEET and the .875 as INCHES to produce 156.8750 or 156 7/8".

The formula i'm using now...
=((A1-(mod(A1,1)))*12)+((A1-(A1-(mod(A1,1))))*12)&""""

 

[Scott Huish]

Google does have a forum for Google Sheets https://productforums.google.com/forum/#!topicsearchin/docs/category$3Aspreadsheets%7Csort:relevance%7Cspell:false

but if you are going to post it here, it should go in the General Excel Discussion and Other Questions forum.

 

[Contech]

ok, thank you.