3 Replies Latest reply on Oct 1, 2018 3:49 PM by elias.daniels.0

    Difference between dates (in Hrs) based on a condition

    elias.daniels.0

      Hi guys,

       

      Can you please help me with this issue.

       

      I'm trying to estimate the difference between dates (In Hrs) depending in the status of each date.

       

      For example, I want the difference from Status 70 to 50, and 90 to 70 within the same booking.

       

      I have been using previous value and Lookup but unsuccessful so far.

       

      From this example:

       

       

      I would like to have a field that will calculate:

       

      Difference 70-50: 1.28 Hrs

      Difference 90-70: 0.81 Hrs

       

      The same for the following booking, etc...

       

      I must be missing something!

       

      Thanks in advance,

       

      Elias