I am stuck trying to seperate overlapping times. The situation is that I have 5 devices requiring x amount of material at the differing durations. What I need to do is seperate the durations and add the demands together for the new duration, but there can be as many as 5 overlapping demands; here is an example of the times and demands
4:31:26 to 4:35:50 4
4:31:26 to 4:35:38 2
4:32:10 to 4:33:20 8
4:33:15 to 4:34:10 9
I need to create individual times and total demands for those times for thousands of lines of time stamps.