+ Reply to Thread
Results 1 to 4 of 4

Excel and time attendance resolving how many time user was IN and OUT

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    05-24-2013
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    291

    Re: Excel and time attendance resolving how many time user was IN and OUT

    Hi Sasa,

    pls find attached solution with the help of pivot table.

    we cant track each time user spent time inside because , use has not swipe in or out properly, there are only 5 transactions can be track his spending time in office highlighted in yellow
    Attached Files Attached Files
    Click on * below if you find this helpful

    Thanks,
    A

  2. #2
    Registered User
    Join Date
    08-20-2013
    Location
    Belgrade,Serbia
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Excel and time attendance resolving how many time user was IN and OUT

    Hi Amy_d2 ,
    first of all thank you for helping me with this,appreciate it.

    Yes i have seen that user didnt swipe properly.
    Here is another export with proper swipe.Swipe Records.xls
    Also if user by mistake swipe two times is there a formula to somehow ignore and use one record?
    Here is example:

    Sale 12:15 in
    Sale 12:22 exit
    Sale 12:23 exit

    Can we calculate last time (12:23 exit ) and ingore 12:22 time?

  3. #3
    Registered User
    Join Date
    08-20-2013
    Location
    Belgrade,Serbia
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Excel and time attendance resolving how many time user was IN and OUT

    I have make an error in thread name...i do not need how many time user has ben inside and out....i need time spend in ,( how many time user has been inside office...2hour,4hour..etc..)

+ 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. [SOLVED] Excel - INDEX, MATCH, SUMIFS?! TIME & ATTENDANCE REPORT
    By ccernat in forum Excel General
    Replies: 12
    Last Post: 08-20-2013, 04:57 AM
  2. Need actual time spent on resolving tickets in night shift
    By Guest79 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-18-2013, 04:22 AM
  3. [SOLVED] time & attendance 3
    By sscssc in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-16-2012, 07:09 AM
  4. Ready Time, Start Time, Finish Time by user
    By teguigala in forum Excel General
    Replies: 3
    Last Post: 02-15-2012, 03:34 PM
  5. Time & Attendance
    By Dan_B in forum Excel General
    Replies: 1
    Last Post: 01-13-2010, 04:12 PM

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