Hello,
Does a function exist to convert metric length measurements into imperial expression.
I would like to convert meter into ft/inch/fraction in an easy way.
e.g. 4.5 mtr converts in 14 ft, 19-4/9 inches.
I made the conversion already in cell formulas but would prefer an easy and less error prone way.
Perhaps there is even a macro known to do the conversion.
Any feedback is much appreciated.
Thanks
Do you want to do more calculations with the result of the conversion?
No actually just the conversion. (using it as conversion engine 
)
CONVERT function:
https://help.libreoffice.org/latest/en-ZA/text/scalc/01/func_convert.html?DbPAR=CALC#bm_id3148446
Thanks but it’s not doing exactly what I had in mind.
when converting to “ft” it is converting "only to feet, when converting to “in” only into inches.
Not as I hoped into nn “ft”, nn “in”, fraction of “in”.
see example spreadsheet.
Metric2ImperialConversion.ods (38.3 KB)
Function SillyConversion(Meter as double) as string
Inches = Meter*1000/25.4
Foots = int(Inches/12)
RemainderInches = Inches-Foots*12
SillyConversion = Foots & " ft," & " " & Format(RemainderInches, "# #/#") & " in"
end function
SillyConversion.ods (16.5 KB)
Maybe, just simpler calculations and using imperial fractions such as 1/8ths (or 1/16ths) , not 1/9ths would work better, see the yellow squares
Metric2ImperialConversion128742EA.ods (20.4 KB)
I can hardly think of a way to do it less error prone than with thoroughly considered spreadsheet formulas.
However, just for fun I wrote user code for the conversion of reasonable values to representations with arbitrary subdivisions. Of course, I did this in a generalyzing way, and not yust for “imperial” length values. My playground was mainly the funny Pound, Shilling, Peny currency.
Of course I would also prefer to offer retirement to time representations which are based on about 3000 years old (mis?) conceptions.
We would easily learn to do it with cd (centi-day, not candela) e.g.
The scientific s (second) should remain unchanged.
Even the USA joined the metre convention more than 100 years ago, and GB reformed their currency suibdivision to decimal, and introduced ISO paper sizes.
See attachment:
disask_128742_xFormat_justforfun.ods (38.5 KB)