Calculating Overtime for a Semi-Monthly Hourly Employee using OT Method 1

In this scenario we will assume that the Pay Week for Overtime Calculations is Sunday and the OT Method is set to 1. These are set up in PAY: Defaults. OT Method 1 calculates any hours worked over 40 in a pay week will be paid at time and 1/2 for all employees. We will look at a payroll for 04/16/08 through 04/30/08.

An hourly employee has the following hours for this pay period:

1st week

Wed April 16 – 15.34 hours

Thur April 17 – 7.82 hours

Fri April 18 – 11.54 hours

Sat April 19 – 0 hours

Total Hours – 34.70

2nd Week

Sun April 20 – 0 hours

Mon April 21 – 11.75 hours

Tue April 22 – 7.74 hours

Wed April 23 – 11.60 hours

Thur April 24 – 7.45 hours

Fri April 25 - 11.92 hours

Sat April 26 – 0 hours

Total hours – 50.46

3rd Week

Sun April 27 – 0 hours

Mon April 28 – 11.74 hours

Tues April 29 – 7.65 hours

Wed April 30 – 11.35 hours

Total Hours - 30.74

Total hours 115.90

In order to calculate the OT for the 1st week we need to look at the entire pay week.

Sun April 13 – 0 hours

Mon April 14 – 8.25 hours

Tues April 15 – 7.50

Total Hours – 15.75

1st week

15.75 (hours from the previous pay period) + 34.70 current pay period = 50.45 total hours

50.45 total hours minus 40.00 reg hours = 10.45 Overtime hours

2nd week

50.46 total hours minus 40.00 reg hours = 10.46 Overtime hours

3rd week

30.74 total hours (will be paid at straight time, these hours will be used to calculate OT for next payroll)

Total OT hours paid 20.91