+ Reply to Thread
Results 1 to 2 of 2

Timesheet Attendance Checker

  1. #1
    Registered User
    Join Date
    11-14-2008
    Location
    Papua New Guinea
    Posts
    14

    Timesheet Attendance Checker

    Hi All
    I work in mining where most staff are paid on a day rate, i.e. paid only when on site.
    I'm looking at creating a check with our travel data and comparing to hours from our payroll system to ensure that there are no hours being paid for staff that are offsite.
    I'm a little stuck how to create this, wondering if anyone out there has a solution and can help.

    Attached sample.
    There are two tabs, the travel/attendance records and the hours data from the payroll system.
    Hoping that someone has a solution for me.
    Thanks
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,944

    Re: Timesheet Attendance Checker

    So are you saying that you need to cross reference between the two sheets to ensure that if someone is shown on the Attendance sheet as something other than Worked then there are no hours recorded on Time Sheet data for the equivalent day?

    eg

    Lisa shows as R&R for 05/09/22 so you need to check no hours exist for her on that day?
    If someone has helped you then please add to their Reputation

+ 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. Replies: 1
    Last Post: 01-30-2020, 11:37 PM
  2. Attendance: get the lateness or of workers on different shi
    By biglucky in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-23-2019, 01:02 PM
  3. Replies: 10
    Last Post: 03-17-2016, 05:34 AM
  4. Need Help - AutoCalculate Attendance Points for employee attendance records
    By switzd0d in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-17-2015, 03:00 PM
  5. Need timesheet to populate attendance/billing sheet
    By Pinkerton in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-07-2013, 07:10 PM
  6. Replies: 3
    Last Post: 06-12-2011, 02:56 PM
  7. Checker help - i'm new don't flame
    By MADTJ in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 10-09-2006, 06:01 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