convert decimal in imperial weight

R

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
 
N

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
 
J

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
 
G

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top