Scheduling production orders - College Project

Hello everyone!

I'm new to the Microsoft Excel. I hope I can explain my problem in the easiest way. I'm doing a college project.

In my attachment you can see 2 tables that represent the weekly production orders in a filling production line. In the first column I have the quantity of products that are needed. The second column is the description of the product to be produce. In the third column I have the quantity of hours that are needed to produce the product (eg. 3,843 = 3 hours and 51 minutes). Then I have the begging hour and data of the production and the end. The remaining hours are for doing the changes to produce the different products. The production line is scheduled in 2 shifts of 8 hours with a 30 minutes breaks. From 07:00 to 15:30 and 15:30 to 00:00.

What I need to do in the second table is to determine what is the quantity of products that I need to produce each day. I now how I can do it in a "manual way" but I don't know how I can write, systematize and standardize this in Microsoft Excel.

I hope I have explained my problem well.

Can you help me please?

Thanks a lot!

Regards,

Joćo