+ Reply to Thread
Results 1 to 1 of 1

Login/Logout Report Summary with Late Login/Early Logout Indicator

  1. #1
    Registered User
    Join Date
    10-14-2012
    Location
    Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    3

    Exclamation Login/Logout Report Summary with Late Login/Early Logout Indicator

    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
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Login - Logout report
    By vamshi57 in forum Excel General
    Replies: 9
    Last Post: 04-19-2016, 12:38 AM
  2. login and logout time , with total login time ,break> 1 hours
    By shrinivasmj in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-12-2013, 05:37 AM
  3. Login and Logout Template
    By carlzilla in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-15-2012, 02:59 AM
  4. Login Logout Report
    By excelnightmare in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-02-2011, 01:45 PM
  5. First login & last Logout
    By Vikky in forum Excel General
    Replies: 2
    Last Post: 08-19-2006, 01:20 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1