Converting

[Sydney288]

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

 

[mopp1]

I got it to work! thank you! Now if i were to want to multiply that by just the number 3, how would i do that with a formula? I tried taking what the formula spat out and multiplying it by 3 but that didn't work :/

Do your math on lengths in inches then convert to the format of your choice

to change from ff-ii-ss (in A1) to inches =LEFT(A1,2)*12+MID(A1,4,2)+RIGHT(A1,2)/16


to change from inches (in B1) to X'Y p/q" use
=TEXT(INT(B1/12),"0")&"'"&TEXT(INT(MOD(B1,12)),"0")&IF(MOD(B1,1)," "&CHOOSE(ROUND(MOD(B1,1)*16,0)+1,"","1/16","1/8","3/16","1/4","5/16","3/8","7/16","1/2","9/16","5/8","11/16","3/4","13/16","7/8","15/16")&"""","""")


to change from inches (in B1) to ff-ii-ss use
=TEXT(INT(B1/12),"00")&"-"&TEXT(INT(MOD(B1,12)),"00")&"-"&TEXT(MOD(B1,1)*16,"00")