Calculate Pounds and Onces to Pounds decimal

[Outdoorsman80]

I'd like to convert a weight such as 1 pound 14 ounces to just pounds, so that would be 1.875 pounds.

1 pound is 16 ounces, plus 14 more is 30 ounces. 30 / 16 = 1.875. 1 oz = 0.0625 lb.

I've been going back and forth on how to come up with a conversion formula.

Work.xlsx
	Q	R	S	T	U	V
2	Set	Part	Pounds	Ounces	Bird Total	Year
3	1	Rooster Breast	1	1		2021
4	1	Rooster Leg	1	5.4		2021
5	2	Rooster Breast	1	0.6		2021
6	2	Rooster Leg	1	8.1		2021
7	3	Hen Breast	0	15.2		2021
8	3	Hen Legs	1	4		2021
9	3	Hen Tender	0	3.9		2021
Data

 

[Saba Sabaratnam]

=S3 + T3/16

Kind regards

Saba

 

[Outdoorsman80]

I was really over-complicating it in my thought process... that makes a lot of sense. Thank you.

 

[Saba Sabaratnam]

No problem

Kind regards

Saba