Skip to Content
0
Dec 09, 2020 at 08:44 PM

DateDiff Help between 2 different sources

25 Views Last edit Dec 09, 2020 at 08:46 PM 3 rev

Hello,

I'm currently attempting to create a formula that retrieves the time difference between two different rows, with some caveats. Example of data below:


What I'm trying to do, is calculate the datediff between a 'transtype' of TR with a transtype of 'FIN', as well as calculate the datediff between a 'transtype' of TR with a transtype of 'D'.

In theory, what I'm trying to get is the time it takes from a call received, to the time it was finished, as well as to the time it took to dispatch from time received. You can see that various dispatches occurred, so it would have to account for each unique dispatch.

(I tried using a "next" and "previous" formula but that didn't quite work, since I'm trying to connect the datediff between transtypes to one another).


As a bonus: is there any way to tie in the formulated datediff for 'D', and have it attached to the specific 'userid' that is in the same row?


Thank you for your time and assistance.

Attachments