Calculate number of hours that are overlapping

[samanthabelfy]

I have a table of data with dates and times and need to calculate the number of hours that are overlapping. I've seen resources for dates but nothing really with dates and times. Any help would be so appreciated!

[Omid_Motamedise]

What do you mean overlaping, you ,want to calculation duration per each row or overlaping of different rows?

[samanthabelfy]

I need to calculate the number of hours that overlap between all of the rows. 

[jgeddes]

I have attached a .pbix file that has a potential solution for you, though I am not certain how quickly it will run on an actual dataset.
As a small example I started with...

and end up with...

The general idea is to create a list of billed minutes for each entry. Take the generated list of billed minutes for each entry and group them together so you will know which billed minutes have multiple entries. From there I did some table transformations to get the overlapping entries listed for each billed minute. Then grouped by overlapping entries, some more transfomations to format the results and then merge that table back into the main table.