Payroll Calculation Examples - 28 Day Cycle

PAY PERIOD 1

Week 1 ​ ​ ​ ​ ​ ​ ​ ​
Time CodeSundayMondayTuesdayWednesdayThursdayFridaySaturdayTotals
ACT 8.08.08.09.06.0 39.0
Week 2 ​ ​ ​ ​ ​ ​ ​ ​
Time CodeSundayMondayTuesdayWednesdayThursdayFridaySaturdayTotals
ACT 12.010.09.010.010.0 51.0

Total Hours Worked

Any hours that represent time worked by an employee should be added together to get this total. ​ ​ ​ ​ACT 90

Total Hours Worked

90

 

Part 1: Overtime Calculation ​ ​ ​
 DefinitionCalculationTotal Hours
Overtime (Ex. OTA)Equals Total Hours worked minus 160 (ONL is not considered in this calculation).90 – 160 = 00
​Holiday Overtime (Ex. HOW, HOA, HWL)​Equals all hours worked on a holiday by either a covered or exempt employee.​n/a​n/a
Preliminary Regular (REG) HoursTotal Hours worked minus all overtime (holiday and regular)90 – 0 = 9090
Part 2: Leave Hours & Holiday Pay ​
Leave Hours (Ex. SIC, VAC,)All leave hour codes including holiday. These codes will all be listed on the payroll register separatelyNo leave was codedn/a
Holiday Pay (HOL)Time is always paid to an employee. It is a day of exemption from work for which employees are paid as if they had workedNo HOL was codedn/a
Part 3: RHH Calculation ​ ​ ​
Preliminary Payable HoursPreliminary regular hours and add all leave hours and holiday hours plus HOW X 1.590 + 0 + 0 = 9090
RHH or GRT

Preliminary Payable Hours – pay period hours in the system (usually 80)

If the calculation is a positive (+) number record as RHH

If the calculation is a negative (-) number record as GRT

90 – 80 = (+) 10RHH 10
Final REG hours

If the previous question resulted in RHH: Preliminary Regular hours minus RHH

If the previous question resulted in 0 or GRT: Preliminary Reg Hours equals Final Reg Hours

90 – 10 = 80REG 80
Payroll Register for Pay Period 1 ​

Paid

80 REG

Accrued

10 RHH

 

 

PAY PERIOD 2

Week 1 ​ ​ ​ ​ ​ ​ ​ ​
Time CodeSundayMondayTuesdayWednesdayThursdayFridaySaturdayTotals
ACT4.08.08.08.08.08.0 44.0
ACT 3.03.03.03.03.0 15.0
Week 2 ​ ​ ​ ​ ​ ​ ​ ​
Time CodeSundayMondayTuesdayWednesdayThursdayFridaySaturdayTotals
HOL 8.0     8.0
HOA 3.0     3.0
ACT  9.09.011.011.014.054.0

Total Hours Worked

 

​		Any hours that represent time worked by an employee should be added together to get this total. ​ ​ ​ ​

ACT 44

ACT 15

ACT 54

HOA 3

Total Hours Worked

 116

 

Part 1: Overtime Calculation ​ ​ ​
 DefinitionCalculationTotal Hours
Overtime (Ex. OTA)Equals Total Hours (from both pay periods) worked minus 160 (ONL is not considered in this calculation)

90 (Pay Period 1)

+ 116 (Pay Period 2) = 206

206 – 160 (Total Month Hours)  = 46

46 OTA

​Holiday Overtime (Ex. HOW, HOA, HWL)​Equals all hours worked on a holiday by either a covered or exempt employee.​HOA 3​3 HOA
Preliminary Regular (REG) HoursTotal Hours worked minus all overtime (holiday and regular)116 (PP2) – 3 (HOA) – 46 (OTA) =6767
Part 2: Leave Hours & Holiday Pay ​ ​ ​
Leave Hours (Ex. SIC, VAC,)All leave hour codes including holiday. These codes will all be listed on the payroll register separatelyNo leave was codedn/a
Holiday Pay (HOL)Time is always paid to an employee. It is a day of exemption from work for which employees are paid as if they had workedHOL 88
Part 3: RHH Calculation ​ ​ ​
Preliminary Payable HoursPreliminary regular hours and add all leave hours and holiday hours plus HOW X 1.567 + 8 + 0 = 75
RHH or GRT

Preliminary Payable Hours – pay period hours in the system (usually 80)

If the calculation is a positive (+) number record as RHH

If the calculation is a negative (-) number record as GRT

75 – 80 = (-) 55 GRT
Final REG hours

If the previous question resulted in RHH: Preliminary Regular hours minus RHH

If the previous question resulted in 0 or GRT: Preliminary Reg Hours equals Final Reg Hours

Was GRT of 5, so using preliminary regular hours67 REG
Payroll Register ​

Paid

8 HOL

5 GRT

67 REG

80

Accrued

6 HOA (3 x 1.5=.4.5)

69 OTA (46 x 1.5=69)

 

 

  

EXAMPLE 2

PAY PERIOD 1

Week 1 ​ ​ ​ ​ ​ ​ ​ ​
Time CodeSundayMondayTuesdayWednesdayThursdayFridaySaturdayTotals
ACT 8.08.08.58.08.0 40.5
Week 2 ​ ​ ​ ​ ​ ​ ​ ​
Time CodeSundayMondayTuesdayWednesdayThursdayFridaySaturdayTotals
ACT 4.58.512.5118.0 44.5

Total Hours Worked

 

​		Any hours that represent time worked by an employee should be added together to get this total. ​ ​ ​ ​ACT 85

Total Hours Worked

85

 

 
Part 1: Overtime Calculation ​ ​ ​
 DefinitionCalculationTotal Hours
 Overtime (Ex. OTA) Equals Total Hours worked minus 160 (ONL is not considered in this calculation) 85 – 160 = 0 0
​Holiday Overtime (Ex. HOW, HOA, HWL)​Equals all hours worked on a holiday by either a covered or exempt employee. ​n/a​n/a
Preliminary Regular (REG) HoursTotal Hours worked minus all overtime (holiday and regular)85 – 0 = 8585
Part 2: Leave Hours & Holiday Pay ​ ​ ​
Leave Hours (Ex. SIC, VAC,)All leave hour codes including holiday. These codes will all be listed on the payroll register separatelyNo leave was codedn/a
Holiday Pay (HOL)Time is always paid to an employee. It is a day of exemption from work for which employees are paid as if they had workedNo HOL was codedn/a
Part 3: RHH Calculation ​ ​ ​
Preliminary Payable HoursPreliminary regular hours and add all leave hours and holiday hours plus HOW X 1.585 + 0 + 0 = 8585
RHH or GRT

Preliminary Payable Hours – pay period hours in the system (usually 80)

If the calculation is a positive (+) number record as RHH

If the calculation is a negative (-) number record as GRT

85 – 80 = (+) 5RHH 5
Final REG hours

If the previous question resulted in RHH: Preliminary Regular hours minus RHH

If the previous question resulted in 0 or GRT: Preliminary Reg Hours equals Final Reg Hours

85 – 5 = 80REG 80
Payroll Register for Pay Period 1 ​

Paid

80 REG

Accrued

5 RHH

PAY PERIOD 2

Week 1 ​ ​ ​ ​ ​ ​ ​ ​
Time CodeSundayMondayTuesdayWednesdayThursdayFridaySaturdayTotals
ACT 7.0 8.58.08.5 32.0
HOL  8.0    8.0
Week 2 ​ ​ ​ ​ ​ ​ ​ ​
Time CodeSundayMondayTuesdayWednesdayThursdayFridaySaturdayTotals
ACT 8.08.09.012.011.0 48.0

Total Hours Worked

 

​		Any hours that represent time worked by an employee should be added together to get this total. ​ ​ ​ ​

ACT 32

ACT 48

 

Total Hours Worked

80

 

Part 1: Overtime Calculation ​ ​ ​
 DefinitionCalculationTotal Hours
Overtime (Ex. OTA) Equals Total Hours (from both pay periods) worked minus 160 (ONL is not considered in this calculation)

85(PP 1)+80 (PP 2) = 165

165 – 160 = 5

5 OTA
​Holiday Overtime (Ex. HOW, HOA, HWL)​Equals all hours worked on a holiday by either a covered or exempt employee. ​n/a​n/a
Preliminary Regular (REG) HoursTotal Hours worked minus all overtime (holiday and regular)80(PP2) – 5(OTA) =7575
Part 2: Leave Hours & Holiday Pay ​ ​ ​
Leave Hours (Ex. SIC, VAC,)All leave hour codes including holiday. These codes will all be listed on the payroll register separatelyNo leave was codedn/a
Holiday Pay (HOL)Time is always paid to an employee. It is a day of exemption from work for which employees are paid as if they had workedHOL 88
Part 3: RHH Calculation ​ ​ ​
Preliminary Payable HoursPreliminary regular hours and add all leave hours and holiday hours plus HOW X 1.575 + 8 + 0 = 83
RHH or GRT

Preliminary Payable Hours – pay period hours in the system (usually 80)

If the calculation is a positive (+) number record as RHH

If the calculation is a negative (-) number record as GRT

83 – 80 = (+) 33 RHH
Final REG hours

If the previous question resulted in RHH: Preliminary Regular hours minus RHH

If the previous question resulted in 0 or GRT: Preliminary Reg Hours equals Final Reg Hours

75 – 3 = 7272 REG
Payroll Register ​

Paid

8 HOL

72 REG

80

Accrued

3 RHH

7.5 OTA (5 x 1.5=7.5)

 

 


 

 EXAMPLE 3

PAY PERIOD 1

Week 1 ​ ​ ​ ​ ​ ​ ​ ​
Time CodeSundayMondayTuesdayWednesdayThursdayFridaySaturdayTotals
ACT  13.75.27.017.08.050.9
HOL 8.0     8.0
Week 2 ​ ​ ​ ​ ​ ​ ​ ​
Time CodeSundayMondayTuesdayWednesdayThursdayFridaySaturdayTotals
ACT3.09.610.010.0   32.6
ONL      11.011.0

Total Hours Worked

 

​		Any hours that represent time worked by an employee should be added together to get this total. ​ ​ ​ ​

ACT 50.9

ACT 32.6

Total Hours Worked

83.5

 

Part 1: Overtime Calculation ​ ​ ​
 DefinitionCalculationTotal Hours
Overtime (Ex. OTA) Equals Total Hours worked minus 160 (ONL is not considered in this calculation)83.5 – 160 = 00
​Holiday Overtime (Ex. HOW, HOA, HWL)​Equals all hours worked on a holiday by either a covered or exempt employee. ​n/a​n/a
Preliminary Regular (REG) HoursTotal Hours worked minus all overtime (holiday and regular)83.5 – 0 = 83.583.5
Part 2: Leave Hours & Holiday Pay ​ ​ ​
Leave Hours (Ex. SIC, VAC,)All leave hour codes including holiday. These codes will all be listed on the payroll register separatelyNo leave was codedn/a
Holiday Pay (HOL)Time is always paid to an employee. It is a day of exemption from work for which employees are paid as if they had workedHOL 88
Part 3: RHH Calculation ​ ​ ​
Preliminary Payable HoursPreliminary regular hours and add all leave hours and holiday hours plus HOW X 1.583.5 + 8 + 0 = 91.591.5
RHH or GRT

Preliminary Payable Hours – pay period hours in the system (usually 80)

If the calculation is a positive (+) number record as RHH

If the calculation is a negative (-) number record as GRT

91.5 – 80 = (+) 11.511.5 RHH
Final REG hours

If the previous question resulted in RHH: Preliminary Regular hours minus RHH

If the previous question resulted in 0 or GRT: Preliminary Reg Hours equals Final Reg Hours

83.5 – 11.5 = 7272 REG
Payroll Register for Pay Period 1 ​

Paid

72 REG

8 HOL

16.5 ONL (11 x 1.5)

Accrued

11.5 RHH

 PAY PERIOD 2

Week 1 ​ ​ ​ ​ ​ ​ ​ ​
Time CodeSundayMondayTuesdayWednesdayThursdayFridaySaturdayTotals
ACT4.014.39.510.0 10.7 48.5
ONL 11.0     11.0
Week 2 ​ ​ ​ ​ ​ ​ ​ ​
Time CodeSundayMondayTuesdayWednesdayThursdayFridaySaturdayTotals
ACT 13.59.010.86.5  39.8

Total Hours Worked

 

​		Any hours that represent time worked by an employee should be added together to get this total. ​ ​ ​ ​

ACT 48.5

ACT 39.8

 

Total Hours Worked

88.3

 

Part 1: Overtime Calculation ​ ​ ​
 DefinitionCalculationTotal Hours
 Overtime (Ex. OTA) Equals Total Hours (from both pay periods) worked minus 160 (ONL is not considered in this calculation)

83.5 (PP 1)

+ 88.3 (PP 2) = 171.8

171.8 – 160 = 11.8

11.8 OTA
​Holiday Overtime (Ex. HOW, HOA, HWL)​Equals all hours worked on a holiday by either a covered or exempt employee.​n/a​n/a
Preliminary Regular (REG) HoursTotal Hours worked minus all overtime (holiday and regular)88.3 (PP2) – 11.8 (OTA) =76.576.5
Part 2: Leave Hours & Holiday Pay ​ ​ ​
Leave Hours (Ex. SIC, VAC,)All leave hour codes including holiday. These codes will all be listed on the payroll register separatelyNo leave was codedn/a
Holiday Pay (HOL)Time is always paid to an employee. It is a day of exemption from work for which employees are paid as if they had workedNo HOL was codedn/a
Part 3: RHH Calculation ​ ​ ​
Preliminary Payable HoursPreliminary regular hours and add all leave hours and holiday hours plus HOW X 1.576.5 + 0 + 0 = 76.5
RHH or GRT

Preliminary Payable Hours – pay period hours in the system (usually 80)

If the calculation is a positive (+) number record as RHH

If the calculation is a negative (-) number record as GRT

76.5 – 80 = (-) 3.5GRT 3.5
Final REG hours

If the previous question resulted in RHH: Preliminary Regular hours minus RHH

If the previous question resulted in 0 or GRT: Preliminary Reg Hours equals Final Reg Hours

Was GRT of 3.5, so using preliminary regular hours76.5 REG
Payroll Register ​

Paid

76.5 REG

3.5 GRT

16.5 ONL (11x1.5)

91.5

Accrued

17.7 OTA (11.8 x 1.5)