hey all,

I got stuck in one calculation where I need to calculate the overlapping time interval using simple excel built in functions.

Case: There are 5 machines whose states are defined as active and not active within specified time interval. The task is to calculate which time interval(s) these 5 machines are active and when they are not active. Capture.JPG