We have MS Access 2010
From the attached text file export and others like it, I need to be able to batch import and re-import these files to produce the required data.
I need to show each day's logged-out times along with totals for each agent on each day.
Each agent works a different shift, so the report should be based on the shift entered and stored for each agent.
If no login existed for an expected shift, then that time should be considered as well.
There will be multiple txt export files in each batch (one per agent, but replaced regularly for each agent).
I do not need to calculate logout times lasting 6 minutes or less. Assistance is greatly appreciated.
11/17/2014 Agent Logged Out From 11:42am -12:29pm; 2:15pm-2:30pm Total 62min (1.2hrs)