Calculating Time Difference between Start and End Timestamps excluding overlapping of multiple rows.

Hi,  sushmitasur4 

First of all,
Here is a reference, I did some processing to your data, you can use [Date]+[Time] to get the [Date/Time] Column:

Add an index column for identification:

Sort =
SWITCH (
    TRUE (),
    'Table'[Event Num] IN { 1, 2 }, "1",
    'Table'[Event Num] = 3, "2",
    'Table'[Event Num] IN { 4, 5, 6 }, "3",
    'Table'[Event Num] IN { 7, 8 }, "4"
)

Then create a calculate table:

Table 2 =
FILTER (
    CROSSJOIN (
        SELECTCOLUMNS ( 'Table', "Sort1", 'Table'[Sort], "Start1", 'Table'[Start] ),
        SELECTCOLUMNS ( 'Table', "Sort2", 'Table'[ Sort], "End2", 'Table'[End] )
    ),
    [Sort1] = [Sort2]
)

At last, add a table visual, The result is as follow:

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.