Calculation guide
Enter actual hours and full hourly rates, including premiums, for three shift groups. Set unused hours to zero.
Inputs
Day-shift hours
Example entry 20.
Day hourly pay
Example entry 20 (in the selected currency).
Evening-shift hours
Example entry 12.
Evening hourly pay
Example entry 24 (in the selected currency).
Night-shift hours
Example entry 8.
Night hourly pay
Example entry 29 (in the selected currency).
Worked example
| Input | Value |
|---|---|
| Day-shift hours | 20 |
| Day hourly pay | 20 |
| Evening-shift hours | 12 |
| Evening hourly pay | 24 |
| Night-shift hours | 8 |
| Night hourly pay | 29 |
| Result | Value |
|---|---|
| Weighted average hourly pay | 23 |
| Total shift pay | 920 |
Calculation steps
Weighted average hourly pay = ((((Day-shift hours × Day hourly pay) + (Evening-shift hours × Evening hourly pay)) + (Night-shift hours × Night hourly pay)) ÷ ((Day-shift hours + Evening-shift hours) + Night-shift hours))
((((20 × 20) + (12 × 24)) + (8 × 29)) ÷ ((20 + 12) + 8)) = 23
Total shift pay = (((Day-shift hours × Day hourly pay) + (Evening-shift hours × Evening hourly pay)) + (Night-shift hours × Night hourly pay))
(((20 × 20) + (12 × 24)) + (8 × 29)) = 920
How each input affects this example
Each row starts from the worked example and changes one input.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Day-shift hours | 20 | 22 | Weighted average hourly pay | 23 | 22.857143 |
| Day hourly pay | 20 | 22 | Weighted average hourly pay | 23 | 24 |
| Evening-shift hours | 12 | 13 | Weighted average hourly pay | 23 | 23.02439 |
| Evening hourly pay | 24 | 26 | Weighted average hourly pay | 23 | 23.6 |
| Night-shift hours | 8 | 9 | Weighted average hourly pay | 23 | 23.146341 |
| Night hourly pay | 29 | 32 | Weighted average hourly pay | 23 | 23.6 |
