Converting measurements

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

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

Glenn

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!


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

Glenn

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)


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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top