Converting measurements

  • Thread starter Thread starter rmk101575
  • Start date Start date
R

rmk101575

I have a spreadsheet with window sizes in feet and inches. I untimately need
to convert the entire spreadsheet of measurements into total square feet. So,
for example, I have a measurement of 7-4 x 4-6 (7ft 4in x 4ft 6in) and I need
to calculate the measurement into inches. I know how to use the CONVERT to
figure 7ft into inches, but how can I get the whole size into inches? HELP
PLEASE!
 
=N((LEFT(A1,FIND("-",A1)-1)*12+MID(A1,FIND("-",A1)+1,99))*(LEFT(B1,FIND("-",B1)-1)*12+MID(B1,FIND("-",B1)+1,99))/144)
 
rmk101575 said:
I have a spreadsheet with window sizes in feet and inches. I ultimately need
to convert the entire spreadsheet of measurements into total square feet. So,
for example, I have a measurement of 7-4 x 4-6 (7ft 4in x 4ft 6in) and I need
to calculate the measurement into inches. I know how to use the CONVERT to
figure 7ft into inches, but how can I get the whole size into inches? HELP
PLEASE!
Click to expand...


Assuming you have "7-4 x 4-6" all in A1:

=(LEFT(LEFT(A1,FIND("x",A1)-2),FIND("-",LEFT(A1,FIND("x",A1)-2))-1)+
MID(LEFT(A1,FIND("x",A1)-2),FIND("-",LEFT(A1,FIND("x",A1)-2))+1,99)/12)*
(LEFT(MID(A1,FIND("x",A1)+2,99),FIND("-",MID(A1,FIND("x",A1)+2,99))-1)+
MID(MID(A1,FIND("x",A1)+2,99),FIND("-",MID(A1,FIND("x",A1)+2,99))+1,99)/12)
 
Glenn said:
Assuming you have "7-4 x 4-6" all in A1:

=(LEFT(LEFT(A1,FIND("x",A1)-2),FIND("-",LEFT(A1,FIND("x",A1)-2))-1)+
MID(LEFT(A1,FIND("x",A1)-2),FIND("-",LEFT(A1,FIND("x",A1)-2))+1,99)/12)*
(LEFT(MID(A1,FIND("x",A1)+2,99),FIND("-",MID(A1,FIND("x",A1)+2,99))-1)+
MID(MID(A1,FIND("x",A1)+2,99),FIND("-",MID(A1,FIND("x",A1)+2,99))+1,99)/12)
Click to expand...


Which can be shortened to:

=(LEFT(A1,FIND("-",A1)-1)+
MID(A1,FIND("-",A1)+1,FIND("x",A1)-FIND("-",A1)-2)/12)*
(MID(A1,FIND("x",A1)+2,FIND("-",A1,FIND("x",A1))-FIND("x",A1)-2)+
MID(A1,FIND("-",A1,FIND("x",A1))+1,99)/12)
 
Back
Top