Hi
CR XI / Access 2003
I am currently trying to create a formula that will work out the duration that a user has been logged in to a system.
The data looks like...
User ID Action Date/Time
1 Logon 01/01/2006 07:30
2 Logon 01/01/2006 07.38
1 Call 01/01/2006 08:01
1 EndCall 01/01/2006 08:09
2 Call 01/01/2006 08.15
1 Logon 01/01/2006 08.18
2 EndCall 01/01/2006 08:20
1 Call 01/01/2006 08:33
1 EndCall 01/01/2006 08:36
2 Logof 01/01/2006 08:46
etc...
2 Logof 01/01/2006 16:28
1 Logof 01/01/2006 16:37
What I want to know is the time difference between the 1st logon and the last logof for each user per day
I am happy grouping by User and then by day, but I get stuck when trying to work out the duration.
Any help greately received!
Thanks
Vis
CR XI / Access 2003
I am currently trying to create a formula that will work out the duration that a user has been logged in to a system.
The data looks like...
User ID Action Date/Time
1 Logon 01/01/2006 07:30
2 Logon 01/01/2006 07.38
1 Call 01/01/2006 08:01
1 EndCall 01/01/2006 08:09
2 Call 01/01/2006 08.15
1 Logon 01/01/2006 08.18
2 EndCall 01/01/2006 08:20
1 Call 01/01/2006 08:33
1 EndCall 01/01/2006 08:36
2 Logof 01/01/2006 08:46
etc...
2 Logof 01/01/2006 16:28
1 Logof 01/01/2006 16:37
What I want to know is the time difference between the 1st logon and the last logof for each user per day
I am happy grouping by User and then by day, but I get stuck when trying to work out the duration.
Any help greately received!
Thanks
Vis