How to create time allocation from dataset with from- and to- timestamp

[BLB]

Hi, 

I have production data summarized in the below format.

Product Code/Location/Quantity and Production Start and End timestamps:

I have a separate Calendar table which has all the Calendar Dates and Hours.

How can I turn the data table efficiently into a format where the quantities are evenly allocated between the start_time and end_times, so that I can visualise them on an hourly chart?

Many thanks.

[lbendlin]

needs more details. Do you need this by hour?  Are there any hours that need to be excluded? Weekends? holidays?

[BLB]

Hi, as in the original post, I have a separate Calendar table which has all the Calendar Dates and Hours.  My intention is to use that on the x-axis of the output graph.

Thanks

[lbendlin]

What about the exclusions?