Calculate total hours if time ranges overlap

Good Afternoon,

I am trying to determine the total hours of downtime accumulated when there are 2 or more machines down during the same time period. To do this, I need to be able to determine if at any point there are 2 or more pieces of equipment down at the same time, and if this is true, how many hours were overlapped.

The attached spreadsheet shows how the data is presented. Any help would be much appreciated.

Kind Regards,

JL