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?

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?

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?

If I record 68.25 inches, what I would like is in separate columns is: (%)
Feet and (8) inches and 1/4 inch

"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?

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?

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?

If your height, 68.25 is in cell A1. Then in cell B1 put =INT(A1/12) to get
feet, then in cell C1 put =INT(A1-B1*12) to get inches and in cell D1 put
=A1-B1*12-C1 to get the fraction of an inch

Tyro

"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?