convert decimal in imperial weight

[Roy Gudgeon]

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

 

[Niek Otten]

From a Google search this post from Gary's Student:

With kilos in A1, In B1 & C1:

=ROUND(convert(A1,"kg","lbm"),0)
=ROUND(16*(convert(A1,"kg","lbm")-B1),0)

so 17 kilos will show as 37 lbs 8 ozs

 

[Jim Cone]

That should be 13.00333.
The worksheet function "Convert" could be used or
with the result of your division in cell A1 then...

=INT(A1)&" pounds and " &ROUND((A1-INT(A1))*16,2)&" ounces"
--
Jim Cone
Portland, Oregon USA



"Roy Gudgeon"
<[email protected]>
wrote in message
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

 

[Gary''s Student]

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.

 

[Roy Gudgeon]

perfect Jim, thanks to you and the other respondees