I have tried a few different solutions trying to get this to work. I have a calculation that gives me a number "16.5371024734982" which represents 16' 537" Id like to show it at as 16' 5 5/8" or what its real value would be.
MacBook Air 13″, macOS 14.3
I do not understand. Is the 16.537 number the number of feet as a decimal number or is it 16' 537" (60.75 ft)? My calculator says 0.537 is 6.444 inches or about 6 7/16", not 5 5/8". Nothing is matching up in your post so I don't know for sure where to start on a formula. Assuming it is decimal feet,
If 16.537 is in cell B2,
The feet part is =INT(B2)
The inches part is =MOD(B2,1)×12
Format the inches as a fraction. The best that can be done with formatting is to 16th of an inch but it will always be shown in 16ths, not reduced to 8ths or quarters.
I do not understand. Is the 16.537 number the number of feet as a decimal number or is it 16' 537" (60.75 ft)? My calculator says 0.537 is 6.444 inches or about 6 7/16", not 5 5/8". Nothing is matching up in your post so I don't know for sure where to start on a formula. Assuming it is decimal feet,
If 16.537 is in cell B2,
The feet part is =INT(B2)
The inches part is =MOD(B2,1)×12
Format the inches as a fraction. The best that can be done with formatting is to 16th of an inch but it will always be shown in 16ths, not reduced to 8ths or quarters.
Or,
If 16.537 is in cell B2,
Feet in C2 is =INT(B2)
Inches in D2 is =MROUND(MOD(B2,1)×12,1÷32)
Format D2 as fraction with accuracy to 2 digits. It will be as precise as 1/32 but will reduce to 1/16, 1/8, etc as necessary.
The final result in E2 is =C2&"' "&D2&"""
Hide columns C and D after it is all set up.
Is it .537 inches or .537 feet? If 16.537 is 16 ft + 0.537 ft then the formulas I provided will convert it into feet and inches with the inches displayed as a fraction with precision of 1/32". Looking at your table I'm not sure I see the point of converting it from decimal feet to feet and inches, though.
its a calculation of half of a wave length. 468/frequency being 28.300 so the length is 16' & .537 inches. I also have done it in meters. 141/frequency so at 28.300 MHz it would be 4.982 meters long.
Im trying to make is easy for kids to understand. But it is starting to confuse me.
Feet and Inches from Decimal number?
