convert meters to feet/inches
On Mon, 15 Feb 2010 10:06:02 -0800, matt
wrote:
One problem that I have while doing this is that I'd like the results to be
more precise.
I would like 12.35 meters to come out as 40' 6.25"
I'd even like to have the ' and " instead of feet/inches. Is all that a
possibility?
Thanks for help.
=INT(CONVERT(A1,"m","ft"))&"' " &
ROUND(MOD(CONVERT(A1,"m","in"),12)*4,0)/4 & """"
--ron
|