convert decimal in imperial weight
In A1:
=321.08/24 displays the lbs (fractional)
In B1:
=INT(A1) displays integer lbs
In C1:
=CONVERT(A1-B1,"lbm","ozm") displays the residual ozs.
--
Gary''s Student - gsnu200860
"Roy Gudgeon" wrote:
Hi
I have a number, say 312.08 that I want to divide by say 24
and report as weight in pounds and ounces
simple division reports 13.0333
--
thanks in anticipation
Roy
|