In the attached sheet, I have listed downtime in seconds by station number on my production line. If I look at total downtime for the day by simply totaling up column F, I include values that overlap in time, thereby inflating actual seconds down. For example, the downtime event on row 5 occured within the duration of the downtime event in row 4, therefore I would only want to include the 21 second duration of the event from row 4. Is there a formula or table I could create that would omit these values that occur in the same moments in time and only count distinct values?
Bookmarks