Skip to Content
0
Nov 23, 2018 at 06:03 AM

Time between last closed and next start in Sequence of order

35 Views Last edit Nov 23, 2018 at 06:04 AM 2 rev

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.