ExcelBanter - View Single Post

Ron Rosenfeld[_2_]

On Mon, 18 Jun 2012 14:17:38 -0700 (PDT), wrote:

Please can any one help I am trying to set up an easy worksheet that will record fishing weighs lbs & oz.

I want to list each fishermans weight by name the what they have caught and the an overall weigh column as well.

I can get the formular to add the pound and oz together and to round up the oz to make a whole pound.
example 3lbs 13oz and 2lbs 11oz it comes up with 5.24 instead of 6.05

It depends on how you are listing your weights.

If you are entering them with Pounds in Col A, and Ounces in Column B, then the formula would be something like:

=SUM(A:A)+SUM(B:B)/16

On the other hand, if you are entering them like:

=Pounds.Ounces

e.g: 3 lbs 13 oz -- 3.13
2 lbs 11 oz -- 2.11
4 lbs 5 oz -- 4.05 (note that this MUST be entered as 4.05 and NOT as 4.5)

Then you could use something like:

=DOLLARDE(SUM(A:A),16)