Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2025-05-30
Example: Create Related Calculations to Track Worked Hours

Example: Create Related Calculations to Track Worked Hours

This example illustrates how to track hours worked for salaried workers, excluding time off, and holidays for these payroll countries:
  • USA
  • Canada
.
Global Modern Services provides pension account contributions to salaried workers who work more than a certain number of hours a month. To verify worker eligibility for a pension account, you want to track the total worked hours for each worker, excluding any time off or holidays.
  • Set up the worker's holiday calendars.
  • Create a related calculation named
    Scheduled Hours (prorated)
     with proration set to
    Prorate using Days Worked
    .
  • Create a related calculation named
    Hours Worked in Period (unprorated)
     with proration set to
    None of the above
    .
  • Create a
    Salary
     earning based on a compensation element.
Security:
  • Set Up: Calculations - Generic
     in the Core Payroll functional area.
  • Set Up: Time Off (Calculations - Generic)
     in the Time Off and Leave functional area.
  • Set Up: Payroll (Calculations - Payroll Specific)
     in the Core Payroll functional area.
  1. Create an aggregate calculation to calculate hours not worked due to time off and holidays.
  2. Access the
    Create Arithmetic Calculation
     task.
    Create a calculation named
    Scheduled Hours - Hours Not Worked
     with these settings:
    1st Operand
    Operator
    2nd Operator
    Scheduled Hours
    Subtract
    Hours Not Worked
  3. Access the
    Edit Earning
     task for the
    Salary
     earning.
    Add 2 rows to the
    Related Calculations
     section.
    Related Calculation
    Override Calculation
    Hours for Reporting -Result
    Hours for Reporting -Result Line
    Scheduled Hours (prorated)
    Job: Scheduled Hours for Target Frequency (as of Sub Period End Date using PC Freq Override)
    Hours Worked in Period (unprorated)
    Scheduled Hours - Hours Not Worked
    Yes
    Add
Workday calculates the workers' hours based on their weekly scheduled hours, and excludes time off and holidays. When the worker has multiple subperiods, Workday calculates a worker's hours based on:
  • Weekly scheduled hours, prorated by days worked.
  • The time off or holidays in the subperiod.
You can view the hours worked on these reports:
  • View Payroll Results
    .
  • Payroll Register by Period
    .
  • Payroll Register
     for balance period.