Calculating Overtime Pay

[debbieg]

I am in the process of creating a database to track employees hours worked.

Here are my tables:

PayRate:
EmpNo
Dept
HourlyPayRate

HoursWorked:
EmpNo
WorkDate
RegHrs
OTHrs

I'm needing to generate a report that shows Employee, Regular Hours, Overtime Hours, Regular Hours Pay, Overtime Hours Pay for the pay period (2 weeks). The employees get 1.5 times their HourlyPayRate for Saturday and 2 times their HourlyPayRate for Sunday.

For example, let's say John worked 80 Regular Hours, 16 hours on 2 Saturdays, and 8 hours on a Sunday. The report would look like this:

Employee Reg Hrs O/T Hrs Reg Pay O/T Pay
John 80 24 $800 $400

What is an easy way to find if a date within that 2-week pay period is a Saturday or Sunday so that I perform the correct calculation?

Thanks in advance for any help/suggestions,
Debbie

 

[HitechUser]

debbieg,

Use the Weekday function to determine the day of the week.

I hope this helps.

Good Luck...