Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2008
    Daytona Beach, Florida, USA
    Thanked 0 Times in 0 Posts
    I have a payroll & billing database for security officers & other employees that work multiple locations with a table for hours worked (from time and a to time are listed) for each employee by date

    Hours Worked Table
    [attachment=89769:New Picture.bmp]

    and a query which calculates the number of hours worked from the table.

    Timesheet for Payroll
    [attachment=89770:New Picture (2).bmp]

    We are based off of a bi-weekly pay period, but If an employee has over 40 hrs in one week they would receive overtime (OT).

    I need to calculate the OT received per day if they have reached the 40 hours for the week (Sat - Sun), for billing purposes.
    Attached Images Attached Images

  2. #2
    Star Lounger
    Join Date
    Sep 2002
    Hastings, Sussex, England
    Thanked 1 Time in 1 Post

    It's not clear if the employeee is entitled to overtime based on daily or weekly rates, e.g. does overtime worked on a Sunday get paid at a greater rate that overtime worked on a Tuesday. I have assumed different rates.
    Try thinking of this problem in spreadsheet terms. Entries would be grouped per week, and the hours worked totalled. If the total hours for the week equals or exceeds 40, then for each day of that week one column would show the hours worked, the next would show the normal hours for that day, a third would show the difference (Overtime). This could then be multiplied by the appropriate overtime rate to give an amount due.

    All of this can be worked out using queries, and Append/Update queries to write the results to a table.

    This is very simplistic, and in real life you would probably group the normal weekday hours together rather than show them by day.

    But..... there are a myriad of payroll systems out there, that can handle these calculations. Might you be better using an off-the-shelf solution rather than reinventing the wheel?



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts