Converting measurements

[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!

 

[Bob Phillips]

=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)

 

[Glenn]

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!

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]

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)

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)