Hi Excel Gurus,
I have been working in call centre workforce management for quite some time. I had created this excel file to detect any late login/early logout indicator but it seems imperfect.
Three simple rules for my report.
1. Did Agent login/logout on time as per schedule? (e.g schedule 9am to 6pm)
2. Did Agent trying to manipulate login time (login early few minutes and logout after 5minutes later)
3. How many minutes lost during this late login/early logout for each agent.
Appreciate if you can share some of your advanced formula or worksheet to improvise my current one.
Regards,
Kelvin Tan
Bookmarks