My specific issue is in regards to time between different events. I am in Business Objects 4.1. My Example of data:
Date | User |Ticket | Seq | Start | Closed Hour
01/01/2018| AB1234| 1234216| Seq 1| 08:00| 12:01
01/01/2018| AB1234|1328903| Seq 2|12:11|13:00
01/01/2018| AB1234|1762349| Seq 3| 13:03|14:05
01/01/2018| AB1234|1674365| Seq 4| 14:05|16:00
I need to get the time difference between the CLOSED HOUR of each Ticket and the Start Hour of next ticket in Sequence. I have tried different ways but no success. Any expert help would be appreciated.