Help please,
I have a fishing club workbook that I have to sit and work out in Lbs and Ounces.
I have the format for cells as ustom 0" lb". 00" oz."
Once autosum has been applied to a range it will give a total in LBs and Ounces but counts all of the ounces up.
Is there a formula that anyone knows where I can automatically divide the ounces by 16 and any lbs moved to the left of decimal place and remaining ounces shown to the right.
Final sum required would be 34lb. 6oz. if this makes sense
I have a fishing club workbook that I have to sit and work out in Lbs and Ounces.
I have the format for cells as ustom 0" lb". 00" oz."
Once autosum has been applied to a range it will give a total in LBs and Ounces but counts all of the ounces up.
Is there a formula that anyone knows where I can automatically divide the ounces by 16 and any lbs moved to the left of decimal place and remaining ounces shown to the right.
Final sum required would be 34lb. 6oz. if this makes sense
Last edited by a moderator: