Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Calculate time difference

Hi Guys,   I have a data set where is information about email delivering and opening and I want to see how long does it take to user to open the email. Problem is, that I do not have separate colu...
Need Help
EVEAdmin's avatar
EVEAdmin
Post Patron
7 years ago

If you convert the timestap to standard date time, then you calculate the difference between the 2 dates

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Yes, but this works when I have 2 separates columns right?

One columne is "email opened" and another is "email delivered" and I create third column where I use formula "email opened" minus "email delivered", right?

 

problem is that my data looks like the image below

Those 3 rows belong to 1 email, first represent when the email was sent, second when was delivered and third when was opened.

I tried to use some if functions but no result, I got errors or completely wrong numbers

 

Thanks

Lukas

  • EVEAdmin's avatar
    EVEAdmin
    Post Patron
    7 years ago

    Using the formula suggested in that thread, you will add a new calculated column to your model. This new calculated column will allow you to calculate the difference between the 2 dates.