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

    Difference between dates (in Hrs) based on a condition


      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,