Seperating Feet, inches and fractions
If the height is in A1, then in B1 enter:
=A1/12
In C1 enter:
=INT(B1)&"' "&INT(12*(B1-INT(B1)))&""" "&TEXT(MOD(12*(B1-INT(B1)),1),"##/##")
--
Gary''s Student - gsnu200765
"JDay" wrote:
When I measure a students height, I document that height in total inches and
any remaining fraction of an inch. Can I in a different workbook design a
formula that'll separate each the number of feet, then inches and then any
remaining fraction of an inch?
|