Formula or special format to calculate ounces & pounds

[bobgrand]

Hello all,

I am searching for a format or formula that will calculate ounces and pounds.

example

A widget weighs 1 lb and 5 oz's or 21 oz.

If material is 1.5 lbs and need to know the weight of 18 pcs. the total weight should calculate to 23.625 lbs.

Would greatly appreciate anyone's help with this.

thank you
Bob

 

[Eric W]

Just enter the weight as a fraction:

	A	B	C
Widget wt	Qty	Total wt

<tbody>
[TD="align: center"]1[/TD]

[TD="align: center"]2[/TD]
[TD="align: right"]1 5/16[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]23 5/8[/TD]

</tbody>

Sheet1​

Worksheet Formulas[TABLE="width: 100%"] <tbody>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "] [TH]Cell[/TH] [TH="align: left"]Formula[/TH]

<tbody> [TD]

[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C2[/TH]
[TD="align: left"]=A2*B2[/TD]

</tbody>

[/TD]
[/TR]
</tbody>[/TABLE]


You can set the number format to 16ths if you want, so it will show as 23 10/16.

 

[bobgrand]

That works. Thank you so much.

 

[Eric W]

You're welcome.