5 Replies Latest reply on Jul 31, 2012 1:56 PM by dchiler

    Calculating feet and inches into square feet

    jcowgill@jrcdesign.com

      we are currently calculating with inches only - ie 30x30=6.25 s.f. - Calculation is easy. But, many of the things we need to put into the database are MUCH larger than these, some times 25-100 feet in length or height. For example we would like to be able to enter 25'-7" x 10"-2" = 311.26 s.f. We know the algabraic formula, but can't seem to figure out how to format the height and length fields so that it looks like 25'-7" on our reports.

       

      (25feet(12inches)+7") x (10feet(12inches)+10")/144= s.f.

       

      Any help would be fabulous.