I need to roll up several events with overlapping start and stop times. I need the total time of the events without doing a sum of the elapsed time for each event.
Each event in the series has a start time and an end time. The times may or may not overlap. The results need to be one or more time spans that equal the earliest and latest for each consecutive amount of time.
The green are the event time spans and the red is the needed result time. I am at a loss as to how to approach this.
Is there a way to detect gaps in the middle like the chart shows above? So the red is two time spans. I can think of a way to detect that. If the data is always overlapping this works. But my data is not always overlapping.