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.