Bundle,trays conversions

[Gohar hussain]

Hi
I have to create a sheet in excel to calculate total egg production..
Here i have three different units.
Bundles=12 trays
Trays=30 eggs
And eggs
I need a formula which can sum the the production plus old stock in current stock
While maintaining the bundles and trays .
Like if eggs become 30 it should go to trays as 1 ,and if trays become 12 thay should go to bundle as 1.
Thanks

 

[Fluff]

Hi & welcome to MrExcel.
One way would be

+Fluff 1.xlsm
	A	B	C	D	E	F	G	H	I
1	Production			Old stock			Current stock
2	Bundles	Trays	Eggs	Bundles	Trays	Eggs	Bundles	Trays	Eggs
3	5	9	20	2	4	15	8	2	5
4	2	6	20	3	5	10	6	0	0
Main

Cell Formulas
Range	Formula
G3:G4	G3	=A3+D3+INT((B3+E3+INT((C3+F3)/30))/12)
H3:H4	H3	=MOD(B3+E3+INT((C3+F3)/30),12)
I3:I4	I3	=MOD((C3+F3),30)