How set up a spread in pounds & ounces?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Keeping track of catches in fishing tourney.....duh, keeping weights in
pounds and ounces rather than converting.....I forget/ (Old age).
 
Peter said:
Keeping track of catches in fishing tourney.....duh, keeping weight
in
pounds and ounces rather than converting.....I forget/ (Old age).
Click to expand...


Hi Peter

Put Pounds in columnA, Ounces in ColumnB

Use the following formulas to add up the columns

Pounds > =SUM(A2:A15)+INT(SUM(B2:B15)/16) Change the range to suit

Ounces > =MOD(SUM(B2:B15),16) Change the range to suit

This will return the correct weight in pounds and ounce
 
Say your total ounces is in A1...

This formula returns the full pounds: =INT(A1/16)

and this the remaining ounces: =MOD(A1,16)
 
Peter,
One way is to use separate columns for lbs and oz.

Total the lbs with =SUM(A2:A10)+INT(SUM(B2:B10)/16)
Total the oz with =MOD(SUM(B2:B10),16)
 
Peter said:
Keeping track of catches in fishing tourney.....duh, keeping weights in
pounds and ounces rather than converting.....I forget/ (Old age).
Click to expand...
Separating the pounds and ounces for each contestant and with each
contestant's entries (12 or more) is only a partial solution. Have used a
formula in the past that converted on a base of 16 rather than on a base of
10...that is the one I can't remember. Thank you.
 
Back
Top