feet and inches and fractions

[SirSquiddly]

Hi folks,

I have been struggling with converting decimal feet inches and fractions and I am at a stand still. I have managed to convert to metres, and inches, but I am struggling to get to feet, inches and fractions. I am having 3 issues. 1) it is displayed something complex like 4' 3 51/71" (I would want it to 32nds or in its simplest form. 2) I can get it to 32nds but it not simplified e.g., 2' 1 16/32" instead of 1/2. 3) I finally thought I was getting somewhere but 1' 7" = 1' 6 1/1"

Can anyone get me from decimal feet, metres or inches to feet, inches and simply fractions?

I have also split into 2 columns. A = feet B = inches and fractions. is there a way you combine A + B into one cell? Any help much appreciated.

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...-fractions-excel-post5305965.html#post5305965

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).