+ Reply to Thread
Results 1 to 1 of 1

login and logout time , with total login time ,break> 1 hours

  1. #1
    Registered User
    Join Date
    09-01-2012
    Location
    india
    MS-Off Ver
    Excel 2003
    Posts
    19

    Post login and logout time , with total login time ,break> 1 hours

    hi,

    i am looking for macro or vb for below data with

    1. login and logout time
    2.total login time each agent for the day
    3.taken more then 1 hours break for the day agents wise

    Name Date Log in Time IN/OUT Log in Time 1 IN/OUT 1 Office - Intime
    Sindhu 1-Aug-13 10:00 in 10:45 out 0:45
    Sindhu 1-Aug-13 11:00 in 13:30 out 2:30
    Sindhu 1-Aug-13 14:30 in 19:00 out 4:30
    Sindhu 2-Aug-13 9:30 in 11:00 out 1:30
    Sindhu 2-Aug-13 11:10 in 12:30 out 1:20
    Sindhu 2-Aug-13 13:30 in 15:00 out 1:30
    Sindhu 2-Aug-13 15:05 in 16:30 out 1:25
    Sindhu 2-Aug-13 16:45 in 19:10 out 2:25
    Sindhu 3-Aug-13 9:45 in 11:00 out 1:15
    Sindhu 3-Aug-13 11:05 in 12:45 out 1:40
    Sindhu 3-Aug-13 13:45 in 19:00 out 5:15
    Sindhu 4-Aug-13 9:50 in 11:30 out 1:40
    Sindhu 4-Aug-13 11:30 in 13:00 out 1:30
    Sindhu 4-Aug-13 14:00 in 19:00 out 5:00
    Nirm 1-Aug-13 10:00 in 10:45 out 0:45
    Nirm 1-Aug-13 11:00 in 13:30 out 2:30
    Nirm 1-Aug-13 14:30 in 19:00 out 4:30
    Nirm 2-Aug-13 9:30 in 11:00 out 1:30


    can any one modify the macro to get the login and logout time for each agents by date below

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by JBeaucaire; 08-13-2013 at 09:58 AM. Reason: Added CODE tags, as per Forum Rules. Take a moment to read the Forum Rules in the menu bar above. Thanks.

+ 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 Template
    By carlzilla in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-15-2012, 02:59 AM
  3. [SOLVED] Find total login hours
    By compumast in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-10-2012, 08:17 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

Tags for this Thread

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