Consulting | Excel Examples
Conversion of Feet and Inches to Decimal Values
You can create these User Defined Functions: CFeet converts from decimal inches to feet, inches and fractions of inch. The second parameter of CFeet specifies the smallest fraction of inch for rounding. If omitted, fractions are rounded to 9999th's of an inch. CInches converts from feet, inches and fractions of inch to decimal inches.