adding lbs & oz's
Hi guys
KNow you guys can help with this...
I need a formula that will calculate lbs & oz when data is entered:
49.02
35.15
24.13
this needs to take account that 1lb = 16 oz, using decimals it would assume
this once 10 is reached.
I dont want to have the lbs and oz in seperate cells if possible
adding my numbers up manually comes out at 109.14
Hope this makes sense.
--
thanks
Roy
|