How set up a spread in pounds & ounces?

[Guest]

Keeping track of catches in fishing tourney.....duh, keeping weights in
pounds and ounces rather than converting.....I forget/ (Old age).

 

[Paul Sheppard]

Keeping track of catches in fishing tourney.....duh, keeping weight
in
pounds and ounces rather than converting.....I forget/ (Old age).

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

 

[Jim Rech]

Say your total ounces is in A1...

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

and this the remaining ounces: =MOD(A1,16)

 

[Earl Kiosterud]

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)

 

[Guest]

Keeping track of catches in fishing tourney.....duh, keeping weights in
pounds and ounces rather than converting.....I forget/ (Old age).

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.