+ 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
    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?

  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

    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