+ Reply to Thread
Results 1 to 11 of 11

Need a login and logout tracker

  1. 01-20-2016, 09:54 AM #1
    Shakil777
    Shakil777 is offline
    Registered User
    Join Date
    11-20-2015
    Location
    Bangalore, India
    MS-Off Ver
    2013
    Posts
    12

    Post Need a login and logout tracker

    Hi Friends,


    I need a tracker in Excel so that I can Track and get the detailed report of the team.
    The report should give me individual detail and team detail

    Things which I need in Tracker
    Employes EMP ID and name

    Log in time
    Log out time
    Total Break time
    Total number of breaks they have taken with duration detail.
    Productivity duration ( Which is log in time - log out time - Total break duration )
    In a sheet I need to know who all are in which status if they have not logged out and punched in the tracker.

    Let me try to explain it better .

    All my team member have to punch ( Log in ) in this tracker manually and when they want to go for Break they need to Punch break in the tracker and punch back from break once they are back from the break. While going they need to log out once there shift ends.


    I tried a lot but couldn't get it ( M new to excel )

    Need help ..

    Please let me know if you need any more details.

    Thanks
    Last edited by Shakil777; 01-20-2016 at 09:56 AM.
    Reply With QuoteRegister To Reply
  2. 01-20-2016, 11:22 AM #2
    Pete_UK
    Pete_UK is offline
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,728

    Re: Need a login and logout tracker

    It would be helpful if you posted a sample Excel workbook, so we could see what data you have and in what format, and in the sample file you could indicate more clearly what you want to achieve (mock up the resulting output manually).

    Hope this helps.

    Pete
    Reply With QuoteRegister To Reply
  3. 01-20-2016, 12:22 PM #3
    Shakil777
    Shakil777 is offline
    Registered User
    Join Date
    11-20-2015
    Location
    Bangalore, India
    MS-Off Ver
    2013
    Posts
    12

    Re: Need a login and logout tracker

    Please find the attached sample file.
    If you want to add anything more which can help me then please do so ..

    Thanks In advance
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 01-21-2016, 03:32 AM #4
    Shakil777
    Shakil777 is offline
    Registered User
    Join Date
    11-20-2015
    Location
    Bangalore, India
    MS-Off Ver
    2013
    Posts
    12

    Re: Need a login and logout tracker

    Any help on this .......!!
    Reply With QuoteRegister To Reply
  5. 01-21-2016, 05:56 AM #5
    Pete_UK
    Pete_UK is offline
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,728

    Re: Need a login and logout tracker

    Your example file only seems to show what you want to achieve - it does not include examples of your source data, so it is not clear how to transform that into the tables that you show.

    Attach another file which includes a sheet for the data that you start with (no more than about 100 rows).

    Hope this helps.

    Pete
    Reply With QuoteRegister To Reply
  6. 01-21-2016, 06:40 AM #6
    Shakil777
    Shakil777 is offline
    Registered User
    Join Date
    11-20-2015
    Location
    Bangalore, India
    MS-Off Ver
    2013
    Posts
    12

    Re: Need a login and logout tracker

    I am sorry .. I didnt get it .. Please let explain bit more else I need to include or describe
    Reply With QuoteRegister To Reply
  7. 01-21-2016, 07:00 AM #7
    Shakil777
    Shakil777 is offline
    Registered User
    Join Date
    11-20-2015
    Location
    Bangalore, India
    MS-Off Ver
    2013
    Posts
    12

    Re: Need a login and logout tracker

    Please fine the New sheet.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  8. 01-22-2016, 06:41 AM #8
    Shakil777
    Shakil777 is offline
    Registered User
    Join Date
    11-20-2015
    Location
    Bangalore, India
    MS-Off Ver
    2013
    Posts
    12

    Re: Need a login and logout tracker

    Quote Originally Posted by Pete_UK View Post
    Your example file only seems to show what you want to achieve - it does not include examples of your source data, so it is not clear how to transform that into the tables that you show.

    Attach another file which includes a sheet for the data that you start with (no more than about 100 rows).

    Hope this helps.

    Pete



    Hello Peter,

    did you got time to check it ...
    Reply With QuoteRegister To Reply
  9. 01-22-2016, 11:02 AM #9
    Pete_UK
    Pete_UK is offline
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,728

    Re: Need a login and logout tracker

    I still didn't see any raw data, i.e. the data that you get that you want to produce reports from.

    Pete
    Reply With QuoteRegister To Reply
  10. 01-25-2016, 01:31 AM #10
    Shakil777
    Shakil777 is offline
    Registered User
    Join Date
    11-20-2015
    Location
    Bangalore, India
    MS-Off Ver
    2013
    Posts
    12

    Re: Need a login and logout tracker

    Quote Originally Posted by Pete_UK View Post
    I still didn't see any raw data, i.e. the data that you get that you want to produce reports from.

    Pete

    I hope this help you to get some clear view of what I am trying to achieve.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  11. 01-27-2016, 06:52 AM #11
    Shakil777
    Shakil777 is offline
    Registered User
    Join Date
    11-20-2015
    Location
    Bangalore, India
    MS-Off Ver
    2013
    Posts
    12

    Re: Need a login and logout tracker

    Any Help on this Friends....
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Login and Logout Template
    By carlzilla in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-06-2020, 10:55 AM
  2. Login - Logout report
    By vamshi57 in forum Excel General
    Replies: 9
    Last Post: 04-19-2016, 12:38 AM
  3. Macro required for Attendance tracker - Login and Logout
    By nirmalreigns in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-29-2015, 03:19 PM
  4. Login/Logout Report Summary with Late Login/Early Logout Indicator
    By kelwin2504 in forum Excel General
    Replies: 0
    Last Post: 02-17-2014, 07:44 AM
  5. 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
  6. Login Logout userform
    By poitachi in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-19-2010, 03:01 PM
  7. 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1