How set up a spread in pounds & ounces?
 

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

Peter Wrote:
Keeping track of catches in fishing tourney.....duh, keeping weights
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 ounces


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=399441

Say your total ounces is in A1...

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

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

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

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)
--
Earl Kiosterud
www.smokeylake.com

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

"Peter" wrote:

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.