Hey guys first off hey all im new here...
a little background, me and some friends are running a fishing competition this year where we try to catch all the uk native freshwater species and are awarded points based on the percentage weight against the record fish of that species.
weights are measures in lbs oz and dram (2lb 4oz 1dram)
so for example I catch a fish at 1lb 1oz 1dram and the record for that species is 2lb 2oz 2dram how would I calculate the percentage weight of the caught fish against the record in a spreadsheet/database
in this case its easy obviously 50%
16oz = 1lb
16dr = 1oz
btw im a complete novice at this so please be patient with me
I have a list of all native records if anyone can help me out id be greatly appreciative.
Bookmarks