### Title

Calculate inches to feet

### Post

I would like to create a Height field where if you enter a number, it will automatically format it to feet and inches, including the feet (') and inch (") marks. Most parents give their kids' height in inches, so i want to be able to reformat it automatically.

Disclaimer: I can do the math on the fly, but I won't always be the one entering data. Just wanted that out there so I don't appear deficient in simple math ;)

I know it more or less involves dividing the number by 12, but it's the formatting that is proving to be a headache.

Alternatively, if I have both a feet field and inches field, can I make it so that if you enter a number into just the inches field, it does the calc and repopulates both fields (without feet- and inch-mark formatting)?

Feet will be:

Div ( HeightInInches ; 12 )

Remaining inches will be:

Mod ( HeightInInches ; 12 )