(Maybe two additional T / F parameters to control zero feet and zero inches suppression, but that is not totally necessary, but would be great for all users. customary measurement systems, representing 1/12 of a foot and 1/36 of a yard. To convert feet, inches & fractions of an inch to metres or metres to ft.
It would also be great if the function accepted two parameters, the first to be the number to convert and the second being the fractional accuracy desired, 2, 4, 8, 16 and so on, or a custom accuracy, like thirds. Feet to Inches formula in ft 12.000 Inches The inch is a unit of length used primarily in the imperial and U.S. I think it would be best to use a custom VBA function to handle this conversion. I have managed to get the conversion but cant simplify the fractions E.g. The resulting fractions are the closest value based on the. This might be acceptable but there are times it is better to convert to 6 1/4". This tool converts decimal values to their equivalent fractional values. However, in my opinion it does not convert the number correctly when there are either zero inches or zero feetģ7.25 will display as 3' -1/4", which is incorrect.
I got the formula from the internet which will convert a given decimal number in feet / inches with fractions and it is somewhat useful.