Converting measurements
 

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!

Converting measurements
 

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

--
__________________________________
HTH

Bob

"rmk101575" wrote in message
...
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!

Converting measurements
 

rmk101575 wrote:
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)

Converting measurements
 

Glenn wrote:
rmk101575 wrote:
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)


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)