Hi All
I am rather new at this. I am stucked here.
I want to extract a timespand betwen events.
Column A = EventID
EventID that starts with 800 and end with 307
Column B = Logged time
Column C = JobID
JobID the job that has created the event
When JobID reaches 255 it starts over
There are at least two JobID with same name (Thats ok as they each gives an EventID)
I need a code that matches the two EventID (800 and 307) with the same JobID and gives me the timespand between them.
The code must be able to continue EventID 307 does not exist.
Have uploaded a picture of the data.
Please help
Thanks