Converting and adding lbm & ozm

[1fishy]

I am trying to build a spreadsheet to total five separate fish weighed
in pounds and ounces. I need a column for the name of the fisherman,
1st fish, 2nd fish, 3rd fish, 4th fish, 5th fish (each in pounds and
ounces), and a total column in pounds and ounces.
I would also like to designate a point value by the most weight to
least, (160pts 1st, 150pts 2nd ... 10 pts 16th place). I also need a
column to denote a 2 oz penalty for each dead fish, that would then be
subtracted from the total. I also will need to be able to total between
two sheets, so I can show totals for a two day tournament where the 1st
and 2nd day and combined totals are on the same sheet. In this case the
point designation would not have to be figured for the 1st day, only
for the two day total.

I have been pulling my hair out on this one! I have the formula for
converting ozm > lbm, (=INT(CONVERT(C7,"ozm","lbm"))&" lbs " &INT(
MOD(CONVERT(C7,"ozm","ozm"),16))& " oz") but am not sure how to add
these up properly. Any help will be greatly appreciated!!! Thanks in
advance

 

[David McRitchie]

if you are weighing in oz
I would just enter 5 7/16 or 10 8/16

Total just total in norm manner.
If you format as ? ?/16 you will get pounds and ounces.