Pounds to ounces

  • Thread starter Thread starter Fizz
  • Start date Start date
F

Fizz

I have 2 columns for weight.
Col A is in pounds
Col B is in ounces
16 ounces = 1 pound

The columns are totaled using @SUM. Typical totals are 12 pounds and
37 ounces. I want the next line to show the correct presentation which
is 14 pounds and 5 ounces.

How can this be done?
 
Pounds: =SUM(A1:A10)+INT(SUM(B1:B10)/16)
Ounces: =MOD(SUM(B1:B10),16)

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Hello,

I use this very same idea, but I output a text cell as well using
CONCATENATE:

=CONCATENATE(SUM(B2:B29)+INT(SUM(B2:C29)/16),"lbs.","
",MOD(SUM(C2:C29),16),"oz.")

The output is: "42lbs. 15oz." marked as text for this cell, but in
another I keep the numbers for later calculation.

GCS
 
Back
Top