Results 1 to 14 of 14

want to match time in out by employee id to cell from punch card data

Threaded View

  1. #1
    Registered User
    Join Date
    03-24-2016
    Location
    Thailand
    MS-Off Ver
    2010
    Posts
    15

    Talking want to match time in out by employee id to cell from punch card data

    Hi.
    i has employee in-out data from punch card then i import to excel and set sorting & filter
    on Report sheet i want to summary time in-out via date and show every in-out time of employee
    because in one day employee has six time on punch card (in-out,lunch,OT)
    i don't know how to match data of second and third time to show on cell in report sheet

    Thanks for your advance
    N.Sriwimala
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to auto-fill employee time card from another spreadsheet
    By starlab_ in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-22-2016, 02:13 PM
  2. employee time punch
    By skhari in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-16-2015, 01:19 PM
  3. 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
  4. [SOLVED] Transpose the Punch Time
    By skandkamat in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-30-2013, 01:12 AM
  5. How can I set up a punch card in Excel?
    By Jenna's dad in forum Excel General
    Replies: 3
    Last Post: 06-10-2012, 06:33 PM
  6. Help with macros for employee punch clock
    By rageo in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-16-2009, 10:05 PM
  7. HOW CAN I FILL AN EMPLOYEE CARD WITH EXACT DAYS CALENDAR
    By LARGO16 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-19-2005, 09:06 AM

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