inputting feet and inches

  • Thread starter Thread starter Lesa
  • Start date Start date
L

Lesa

I'm trying to input feet and inches into excel and I
don't want to have to change everything to inches or
decmials (ie fortytwo feet three inches and 2/16 I want
to read 42 3 2/16)and then I want to add or subtract in
the same way. Is there any way to do this?
 
Thanks that works great. I hate to ask but is there a formula that will do just the opposite, 42'-3 1/8" and turn it into decimal feet (42.260)

Thanks again for the help
Lesa
 
Hi Lesa,
Based on Bernie's formula at
http://www.mvps.org/dmcritchie/excel/formula.htm#carpentry
a formula to take Feet and Inches back to a number of inches (based on Bernie Deitrick's previous solution)
=VALUE(LEFT(A1,FIND("'",A1)-1))*12 + VALUE(MID(A1,FIND("'",A1)+1,FIND("""",A1)-FIND("'",A1)-1))
----
a1:
42' 3 1/8"

-- assuming you don't want a subtraction

B1:
simply divide the above formula by 12
for a formula to take Feet and Inches back to a number of feet (based on Bernie Deitrick's previous solution)
=(VALUE(LEFT(A1,FIND("'",A1)-1))*12 + VALUE(MID(A1,FIND("'",A1)+1,FIND("""",A1)-FIND("'",A1)-1))) / 12
 
Back
Top