cheryl27284
Technical User
I need to figure out the duration of time someone logged off the phone for different reasons. Each record has a logoff and a Logon. In order to determine the duration I have to look at the very next record to see what the logon was. If someone logs off for a reason (reasons are numeric 1-5)the record will tell me the time they logged off but not the duration. The next record tells me when they logged back in. I have to compare the very next record. How do I do this?
table looks like below:
EmployeeID reason logon logoff
444 2 10/11/2005 12:00 AM 10/11/2005 12:05 AM
444 1 10/11/2005 12:10 AM 10/11/2005 12:30
table looks like below:
EmployeeID reason logon logoff
444 2 10/11/2005 12:00 AM 10/11/2005 12:05 AM
444 1 10/11/2005 12:10 AM 10/11/2005 12:30