Results 1 to 2 of 2

Time Punch Contact Tracing

Threaded View

  1. #1
    Registered User
    Join Date
    03-18-2020
    Location
    Dallas, USA
    MS-Off Ver
    2020
    Posts
    38

    Time Punch Contact Tracing

    Hi Team,

    I have an output (attached) which shows the time punches of fictional employees.
    In column J through L, there are a times/dates which are identified as compromised for one reason or another.

    I want to identify and filter to ONLY the times and dates for employees in columns A through E that overlap with the ones in J through L.

    I have tried everything and the only ways I have found are incredibly manual.

    Does anyone have a way to do this quickly and/or efficiently?
    Attached Files Attached Files
    Last edited by TSACov; 10-20-2020 at 11:47 AM.
    Thanks!
    - TSACov

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Need help with Punch in and Punch out clock system please.
    By Grassman in forum Excel Programming / VBA / Macros
    Replies: 74
    Last Post: 02-27-2020, 02:16 AM
  2. Time calculator returning negative result until punch-out is recorded?
    By taylorsm in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 08-18-2018, 06:39 AM
  3. Punch in Time clock problem
    By giverny in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-12-2018, 06:43 AM
  4. employee time punch
    By skhari in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-16-2015, 01:19 PM
  5. Add, retrieve and save- time punch
    By skhari in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-08-2015, 11:45 PM
  6. Clock in multiple punch in/punch out times Formula
    By Schnizzle74 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-24-2014, 06:15 PM
  7. [SOLVED] Transpose the Punch Time
    By skandkamat in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-30-2013, 01:12 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