Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Measurements in cells? | Excel Discussion (Misc queries) | |||
Time measurements fromulas? | Excel Discussion (Misc queries) | |||
convert measurements | Excel Worksheet Functions | |||
Height/Width measurements | Excel Worksheet Functions | |||
Metric to imperial measurements | Excel Discussion (Misc queries) |