|You posted the results that you are looking for, but you didn't post the original values, so it's a little tough for us to offer a specific solution/formula.|
In general, if you divide the number of ounces by 16, you'll get the decimal equivalent:
8/16 = .5
9/16 = .5625
If you add that to the number of pounds in your source data, you'll have your answer.
Again, unless we know what your source data looks like, we can't offer much else.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.