Time between last closed and next start in Sequence of order

[former_member593593]

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.

[Former Member]

Order your data as required, I assume Date, User, Seq.

Create formula which will give diff in hours,

@TimeDiff

Datediff('h', StartTime, Previous(ClosedTime)

Don't have Crystal so not sure of symbols for time, I think h = hours, mm = minutes, s = sec

This will not work if diff is over two days

Ian