Hey, i need to count hours between dates. The problem is there is a 1:n. So i have to use a while or something else. Could someone help how to do ?
I need the following:
There are a lot of ticketnumbers in the system. Example attached(1). I need to count all the pause times in hours.
A Ticketnumber can have more that one pause in their lifetime. Now i have to search if there is ActivityAction 5. Use this CreationDate, go to the next event and use this as ClosedDate if this is not a 5 and try to get the duration between the two dates. Is that possible ?