AnsweredAssumed Answered

Calculating feet and inches into square feet

Question asked by on Jul 31, 2012
Latest reply on Jul 31, 2012 by dchiler

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.