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
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi EVEAdmin,

     

    thank you for reply but I am not sure if I follows. On the link you provided is not the solution to my problem or am I missing something?

     

    I dont need to convert timestamp to standard date time (or I needed it and I used the solution from this thread you sent :) )

     

    I need a new measure where will be the difference (EG from my table the first row should be 9:49:10 etc)

     

    Thanks

    Lukas

    • 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