Decimal to Fraction Within another Formula

[JMax85]

Forgive me if the answer is posted somewhere else
I am working on a project for processing steel handrail
and to simplify things for the shop i have a formula that converts Inches In to feet
my issue is if a fraction is the input the output results in a decimal
EX: 100 1/2 comes out as 8' 4.5"
and I would like it to read 8' 4 1/2"
this is the formula i am using how can i modify it to display the fraction

=INT(H19/12)&"' "&MOD(H19,12)&""""

Thank You

 

[Anonymous1378]

Probably

=INT(H19/12)&"' "&INT(MOD(H19,12))&TEXT(MOD(H19,1)," ?/?;;")&""""

 

[JMax85]

Probably

=INT(H19/12)&"' "&INT(MOD(H19,12))&TEXT(MOD(H19,1)," ?/?;;")&""""

Awesome Thank you so much
I don't have any sort of experience or training with excel other than a few 30 min basics Youtube videos
could you possible explain the addition you made and what it means
and any recommendations for where i can learn more about the Formulas/Functions and how to use them

Thank You Again

 

[Anonymous1378]

So I added TEXT(MOD(H19,1)," ?/?;;"). You've already used the MOD() function so I'll just explain the TEXT() function. It's essentially cell formatting in a formula, and there are various cell formats for currencies, dates, percentages, and what was relevant here was fractions. the semi-colons are dividers for various cell formatting options, specifically what to show when a value is a positive number;negative number;zero;not a number. You may find a bit more of what the text function is capable of here.

 

[JMax85]

So I added TEXT(MOD(H19,1)," ?/?;;"). You've already used the MOD() function so I'll just explain the TEXT() function. It's essentially cell formatting in a formula, and there are various cell formats for currencies, dates, percentages, and what was relevant here was fractions. the semi-colons are dividers for various cell formatting options, specifically what to show when a value is a positive number;negative number;zero;not a number. You may find a bit more of what the text function is capable of here.

Awesome Thank You