View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
rmk101575 rmk101575 is offline
external usenet poster
 
Posts: 2
Default 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!