Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Just adding | Excel Discussion (Misc queries) | |||
Adding hrs | Excel Worksheet Functions | |||
Need help adding : | Excel Worksheet Functions | |||
Adding * to the end | Excel Discussion (Misc queries) | |||
Adding with & | Excel Worksheet Functions |