Converting and adding lbm & ozm

[1fishy]

I am trying to build a spreadsheet to total five separate fish weighe
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 an
ounces), and a total column in pounds and ounces.
I would also like to designate a point value by the most weight t
least, (160pts 1st, 150pts 2nd ... 10 pts 16th place). I also need
column to denote a 2 oz penalty for each dead fish, that would then b
subtracted from the total. I also will need to be able to total betwee
two sheets, so I can show totals for a two day tournament where the 1s
and 2nd day and combined totals are on the same sheet. In this case th
point designation would not have to be figured for the 1st day, onl
for the two day total.

I have been pulling my hair out on this one! I am by no mean
experienced with Excel but I'm not lame either. Please don't assume
know anything though. I have been to the Microsoft site and downloade
the necessary addins. 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 ad
these up properly. Any help will be greatly appreciated!!! Thanks i
advanc

 

[BrianB]

The main problem is that the lbs/ozs display is *text* and therefore no
usable for direct calculation.

1. The principle is to do all calculations in pounds (normal decima
numbers) -perhaps in hidden columns - and convert back to lbs & oz fo
display.

2. To avoid too many difficult formulas (and to check results) brea
down the calculations into several columns. (Keep it simple)

3. Have separate lbs & oz columns (say A and B) for input, and conver
to pounds (say column C) with :
=A1+B1/16

4. The reverse calculation of the result into text would be :-
=INT(C1) &" lb " &(C1-INT(C1))*16 &" oz".

Hopefully this will get you started