4 Replies Latest reply on Aug 29, 2018 12:41 PM by christopher berger

    Time difference between rows

    christopher berger

      Hi,

       

      I need some assistance with a datediff calculation. Basically, I have the below "Resource IDs" and each "Resource IDs" can enter a "State" at a specific time. Once, the "Resource IDs" enters a "State" it's considered to be in this "State" until a state change occurs. What I need to do is be able to calculate the total time for each "State" for each "Resource IDs". (E.g. IBP03 -> DOWN -> 34min). The calculated time should update as a filter is applied to the "Updated Date" field. I have looked through the forum and tried several different approaches but couldn't get to the right answer. Unfortunately, I can't attached the work book due to confidentiality. Any help is really appreciated.