Calculating Overlapping Time

[ashleyshsu1]

I work for a call center and we have agents who take live chats, up to two at a time. I need to calculate the total Active Time without duplicating any time they were on two chats concurrently. I have no idea what kind of formula would help me accomplish this task, but then again my excel skills are very basic. Here's a small sample of my data:

Chat Start Time	Chat End Time	Active Time
1/4/2018 7:32	1/4/2018 7:38	0:06:11
1/4/2018 7:35	1/4/2018 7:58	0:22:56
1/4/2018 7:39	1/4/2018 7:48	0:08:37
1/4/2018 7:48	1/4/2018 7:49	0:01:07
1/4/2018 7:50	1/4/2018 8:16	0:25:26
1/4/2018 10:05	1/4/2018 10:20	0:15:25
1/4/2018 10:05	1/4/2018 10:22	0:16:59
		1:36:41

<tbody>
</tbody>

 

[Grizzly Adams]

I’m not exactly sure I understand what it is you need. Could u give an example. I will try my best to help