convert decimal in imperial weight
 

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

convert decimal in imperial weight
 

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
--
Gary''s Student - gsnu200854


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Roy Gudgeon" 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
--
thanks in anticipation
Roy

convert decimal in imperial weight
 

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"

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
--
thanks in anticipation
Roy

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

convert decimal in imperial weight
 

perfect Jim, thanks to you and the other respondees
--
thanks
Roy


"Jim Cone" wrote:

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"

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
--
thanks in anticipation
Roy