Email response time

[Anonymous]

I am trying to calculate the first response time of the emails, also I am trying to figuring out how to match received emails to sent emails,  

 this is an example data, the actual data is thousands of rows long.

Folder Path	Subject	date time sent	date time received	ID	Sender Address	Receiver Address
\Sent Item\	Re:Complaint for service	11/17/2020 10:54	11/17/2020 10:54	aamkiushjjerjerjl	Company@mail.com	Customer@mail.com
\Reeceived item \	Complaint for service	11/16/2020 15:54	11/16/2020 15:54	aamkiushjjerjerjl	Customer@mail.com	Company@mail.com
\Sent Item\	Re:Complaint for service	11/17/2020 11:54	11/17/2020 11:54	aamkiushjjerjerjl	Company@mail.com	Customer@mail.com
\Sent Item\	Re:Complaint for service	11/17/2020 12:54	11/17/2020 12:54	aamkiushjjerjerjl	Company@mail.com	Customer@mail.com
\Reeceived item \	Office timings	11/16/2020 15:54	11/16/2020 15:54	lkjjasg	12445@mail.com	Company@mail.com
\Sent Item\	Followup	11/16/2020 15:54	11/16/2020 15:54	hjjksie	Company@mail.com	5433@mail.com

1) So my question is how to calculate the time between when the initial email was received and when the first response was sent? 

2) Additionally, I want to count those emails as well which are not actioned or respond 

Thanks in advance for your support 

[amitchandak]

@Anonymous , what are the subjects/paths we should consider? Also what happens when you receive more than one email from one sender

[Anonymous]

very good questions I think you understand the complexity we need to consider both exceptions