Conversion Formula
The closest I can easily get is =INT(A1/12)&"'
"&INT(MOD(A1,12))&TEXT(MOD(A1,1),"# ?/?")&""""
which gives 5' 0 5/8"
--
David Biddulph
"dawg" wrote in message
...
I'm looking for a formula to convert distance.
Example:
60.625 to 5' 3/8"
Is this possible?
Can someone help me?
|