Exclude time difference from a date range

[JaiPrakash]

I'm trying to exclude duration of a date range from a set of range that is in another sheet:

Table_1 shows total time in seconds a ticket was assigned to someone
Table_2 shows the time in seconds when the ticket was put on hold

Table_1

ID	Start_Date	End_Date	Duration_In_Seconds	Final_Time_After_Exclusion
INC1	2/18/2020 15:14	2/22/2020 1:14	295200
INC_3	2/18/2020 14:23	2/24/2020 17:30	529620

Table_2

ID	Start_Date	End_Date
INC_3	2/18/2020 12:21	2/24/2020 16:08
INC_1	2/18/2020 15:23	2/22/2020 1:08
INC_1	2/22/2020 17:44	2/24/2020 19:24

Need your help with a formula that exclude time if date range in Table_2 falls between date range present in Table_1.

I tried Index and match but wasn't able to come up with a logic to get this done.
Thanks so much for all the help!!

 

[DRSteele]

INC_3 seems to have been put on hold before it was assigned to someone.
INC_1 seems to have been put on hold after the end date.

Are those conditions possible?

 

[JaiPrakash]

Hello DRSteele,

Apologies for not been able to respond earlier.

Yes, there are instances where it is put on hold before it assigned to someone. If those case what I'm trying to do is to exclude time when the ticket was assigned to an assignee till the time it was on hold. #INC_3 > time to be excluded = 2/18/2020 14:23 till 2/24/2020 16:08.

Thanks