Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Email response time

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 PathSubjectdate time sent date time received IDSender AddressReceiver Address
\Sent Item\Re:Complaint for service11/17/2020 10:5411/17/2020 10:54aamkiushjjerjerjl[email protected][email protected]
\Reeceived item \Complaint for service11/16/2020 15:5411/16/2020 15:54aamkiushjjerjerjl[email protected][email protected]
\Sent Item\Re:Complaint for service11/17/2020 11:5411/17/2020 11:54aamkiushjjerjerjl[email protected][email protected]
\Sent Item\Re:Complaint for service11/17/2020 12:5411/17/2020 12:54aamkiushjjerjerjl[email protected][email protected]
\Reeceived item \Office timings11/16/2020 15:5411/16/2020 15:54lkjjasg[email protected][email protected]
\Sent Item\Followup11/16/2020 15:5411/16/2020 15:54hjjksie[email protected][email protected]

 

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 

 

Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

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