Hi everyone!
I'm new to this forum so i'm hoping you guys can help me out. I'm trying to make a form that will be able to convert a measurement that is in carpenters form to a normal FT'In' Fraction Format.
Ex. 9'6 1/2" is 09-06-08
the front 09-XX-XX stands for Ft, XX-06-XX stands for In, and XX-XX-08 stands for the 16ths of an Inch. so 8/16" is 1/2" Etc.
I'm trying to make a formula that will do this when i load it into Excel.
Please help me



I'm new to this forum so i'm hoping you guys can help me out. I'm trying to make a form that will be able to convert a measurement that is in carpenters form to a normal FT'In' Fraction Format.
Ex. 9'6 1/2" is 09-06-08
the front 09-XX-XX stands for Ft, XX-06-XX stands for In, and XX-XX-08 stands for the 16ths of an Inch. so 8/16" is 1/2" Etc.
I'm trying to make a formula that will do this when i load it into Excel.
Please help me



