See Chip Pearson's site for working with feet and inches.
http://www.cpearson.com/excel/FeetInches.htm
Note the link on that page to Fractional Arithmetic.
Gord Dibben MS Excel MVP
On Tue, 18 Jul 2006 17:30:02 -0700, Bill wrote:
I work a lot with measurements mostly in inches, but I have found a need to
convert them to feet and inches quickly, is there a macro or formula to do
this?