Caculation of difference in time between two records

[Mike Hughes]

Trying to determine the amount of time a USERID stays on the ELOG or NOTE screens.
In this case the user NAV TO ELOG at 12:28.27 pm
Then started viewing CASE 20028294P at 12:28:28 PM
Then the user NAV TO the CMEM SCREEN at 12:28:38 PM
So this user viewed the ELOG screen for 10 seconds

I have attached a copy of the table

I’m trying to figure out how to have a query figure this out for me, using TABLE 2
Anyone have suggestions? Thanks

If it can't be done, it can't be done..........

 

[Mike Hughes]

I don't know how to pull this, but I don't need an answer to this. I'm going to go at it a different way.