Weighted average overtime
If employees work multiple jobs or positions with different pay rates within the same workweek, you can enable this setting to calculate overtime using a blended (weighted average) regular rate. Instead of applying overtime based on a single pay rate, the system calculates a weighted average rate for the week and uses it to determine overtime pay accurately.
Before you start
To setup the weighted average overtime calculation for payroll, you’ll need the Administrator access level or the Manage payroll settings permission enabled.
To setup weighted average overtime:
- Navigate to the Settings menu in the top-right corner.
- Select Pay Rules under the Time & Attendance section.
- Select the pay rule you wanted to configure.
- Use the toggle button beside the Use weighted average (Blended) overtime calculation option to enable/disable this setting.
- Click the Save button at the bottom.
Weighted average overtime scenario:
Let's say an employee is working for position A and position B for the same workweek with the below mentioned duration and wages. The overtime rate is configured as 1.5 times regular rate. Here is how the pay for the workweek is calculated with weighted average overtime.
Position A hourly wage = $10/hour
Position B hourly wage = $20/hour
Position A worked hours = 28 hours
Position B worked hours = 22 hours
Worked Hours | Regular Earnings | Blended regular rate | Overtime premium | Total Pay |
Position A - 28 hrs | $10 * 28 = $280 | Total worked hours = 50 hrs Total regular earnings = $720 Weighted Average rate = 720 / 50 = $14.4 | Overtime hours = 10hrs Overtime premium = 10 x 0.5 x 14.4 = $7.2 | Total Pay = $720 + $7.2 = $727.2 |
Position B - 22 hours | $20 * 22 = $440 |
Access your files securely from anywhere
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
New to Zoho Writer?
Create. Review. Publish.
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
New to Zoho Survey?
Zoho Sheet Resources
Zoho Forms Resources
New to Zoho Sign?
Zoho Sign Resources
Sign, Paperless!
New to Zoho TeamInbox?
Zoho TeamInbox Resources
New to Zoho ZeptoMail?
Design. Discuss. Deliver.
New to Zoho Workerly?
New to Zoho Recruit?
New to Zoho CRM?
New to Zoho Projects?
New to Zoho Sprints?
New to Zoho Assist?
New to Bigin?
Related Articles
Overtime configuration
Overtime rules vary based on country, state, or region and this mostly depends on the regional labor laws. Setting up overtime rules allows organization to pay extra based on the hours that the employees have worked within a certain time frame. In ...Overtime across multiple schedules
Zoho Shifts offers flexible options for calculating employee overtime, allowing you to choose whether overtime hours should be combined across multiple schedules or calculated separately for each schedule. When combined overtime is enabled, total ...Payroll overview
Whether you’re managing a small team or a growing workforce, a payroll ensures employees are paid accurately and on time for their worked hours and wages. In Zoho Shifts, payroll feature simplifies the payroll calculation by seamlessly combining the ...View payroll report
Payroll report allows you to review employee earnings, worked hours, and calculated wages before payroll is finalized. In Zoho Shifts, you can view detailed split of regular worked hours, overtime, double Overtime, paid time-off, total worked hours ...Assigning pay rules
Pay rules define how employee wages are calculated, including overtime, premium pay, and other payroll conditions. Assigning the correct pay rule to each employee ensures payroll is processed accurately and in compliance with company policies and ...
New to Zoho LandingPage?
Zoho LandingPage Resources