Seperating Feet, inches and fractions
Assuming the format you showed is how you want the output to look, maybe
this variation on Gary''s Student's formula....
="("&INT(B1/12)&") Feet ("&MOD(INT(B1),12)&") Inches
"&TEXT(MOD(B1,1),"##/##")&" Inch"
Rick
"JDay" wrote in message
...
If I record 68.25 inches, what I would like is in separate columns is:
(5)
Feet and (8) inches and 1/4 inch
"JDay" wrote:
"Niek Otten" wrote:
Can you give examples of how exactly you enter the height?
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"JDay" wrote in message
...
| 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?
|