+ Reply to Thread
Results 1 to 2 of 2

Searching for times by date and person

  1. #1
    Registered User
    Join Date
    12-20-2011
    Location
    U.S.A.
    MS-Off Ver
    Excel 2010
    Posts
    17

    Searching for times by date and person

    I am working on a timesheet compliance workbook. My goal is to capture how close people are to their scheduled arrivals and departures. I have created a sample workbook. The workbook has three worksheets.

    The first is "Attendance Data". This is meant to represent the data as it is produced by our reporting software. It produces data in four columns. The first is each person, the second the date they logged in or out, the third the time the logged in on each date, and the fourth the time they logged. Note that a person can log out and log in repeatedly on the same date, but I am only concerned about their first login and their last log out of each day.

    The second worksheet is for employee "Alvin". The third is for employee "Bruce". Both are the same, they plot out the expected time for the employee to login each day and the time they log out and the difference in minutes.

    I need help getting the right data from the "Attendance Data" sheet to the "Alvin" sheet. I need Excel to do a search or match or something that goes like this - first it locates ONLY entries for Alvin, then within that data it ONLY locates entries for a particular date, then it displays the FIRST login for that date. The result would go into cell D2 on sheet "Alvin". Then it needs to do the same again in cell G2, this time for the LAST logout for that date.

    I hope this makes sense, I'm happy to provide any clarification that is needed.
    Attached Files Attached Files
    Last edited by nigeli; 08-14-2012 at 10:48 AM. Reason: First and last are completely different!

  2. #2
    Registered User
    Join Date
    12-20-2011
    Location
    U.S.A.
    MS-Off Ver
    Excel 2010
    Posts
    17

    Re: Searching for times by date and person

    I updated this to make it actually be correct.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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