MS EXCEL Convert Height Decimal Feet Inches to Inches Only

Question

Using MS Excel (2010), I would like a formula (Not VBA/Macros) that will convert Decimal Feet, Inches and Fraction of a person's height to Only inches.

Example: John is 6' 1 1/4" tall, I have converted the Total height to decimals = 73.250, and would like to convert the Decimal output to only inches, including fraction of height = 73 1/4"

Answer 1

=INT(H29)&" "&TEXT((H29-INT(H29)),"# #/#")&CHAR(34)

H29 is the cell reference data. This formula is conversion of decimal to only inches format. Answer will come 73 1/4"

And

=CONCATENATE((H29-MOD(H29,12))/12,"' ",ROUNDDOWN(MOD(H29,12),0),IF(MOD(H29,1),CONCATENATE(" ",TEXT(MOD(H29,1),"##/##"),""""),""""))

H29 is the cell reference data. This formula is conversion of decimal inches to feet inches format. Answer will come 6' 1 1/4"