Example: Calculate the Majority of a Shift
This example illustrates how to configure Workday Time Tracking to create calculations to pay workers appropriately depending on when they work the majority of their shift.
At your company, the majority of a worker's worked hours in a shift falls between 6:00 PM and 6:00 AM. Workers are paid a premium rate for their entire shift (called
Shift 2
in this example).- Enable a time shift option on the time entry templates of the workers to whom you want these calculations to apply. See Set Up Time Shift Options.
- Security:Set Up: Time Calculationsdomain in the Time Tracking Calculations functional area.
- Create a shift differential calculation to tag all hours worked between 6:00 PM and 6:00 AM asShift 2.
- Access theCreate Time Calculationtask.
- In theNamefield, enterShift 2 Hours.
- From theCalculation Typeprompt, selectShift Differential Calculation.
- ClickOK.
- On theGeneral Optionstab, specify theCriteria:FieldValueStart Time6:00 PMEnd Time6:00 AM
- In theResultssection, from theAdd Tagsprompt, create aShift 2time calculation tag.
- On theGroupstab, add a row to the grid with these values:FieldValueTime Calculation GroupFull-Time Hourly WorkerEffective DateCurrent Snapshot
- ClickOK.
- Access theMaintain Time Calculation Prioritiestask to assign the calculation priority 045.
- ClickOKandDone.
- Access theCreate Calculated Fieldtask to create calculated fields that build on each other. You use the final calculated field created in this step in the time block conditional calculation.
- Create a calculated field that returns true if a time block is tagged asShift 2.FieldValueField NameTime Block Has Shift 2 Calc TagBusiness ObjectTime BlockFunctionTrue/False Condition
- ClickOK.
- On theCalculationtab, create the true/false condition. Add this row to the grid:And/Or(FieldOperatorComparison TypeComparison Value)AndCalculation Tagsany in the selection listValue specified in this filterShift 2
- ClickOK.
- ClickCreate Another Calculation.
- Create a calculated field that sums all the time blocks in a shift tagged asShift 2.FieldValueField NameTotal Shift 2 Hours for a ShiftBusiness ObjectTime ShiftFunctionSum Related Instances
- ClickOK.
- On theCalculationtab, specify these values:FieldValueRelated FieldTime Blocks for a Time ShiftInstances where condition is trueTime Block Has Shift 2 Calc TagField to SumCalculated Quantity
- ClickOK.
- ClickCreate Another Calculation.
- Create a calculated field that calculates the percent of time in a shift that is tagged asShift 2.FieldValueField Name% of Shift in Shift 2Business ObjectTime ShiftFunctionArithmetic Calculation
- ClickOK.
- On theCalculationtab, from theField Typeprompt, selectNumeric.
- Add these rows to the grid:(Field)OperatorTotal Shift 2 Hours for a Shift/ (Divide)Total Reported Hours for a Shift
- ClickOK.
- ClickCreate Another Calculation.
- Create a calculated field that returns true if the majority of a shift was worked inShift 2.FieldValueField NameMajority of Shift Worked in Shift 2Business ObjectTime ShiftFunctionTrue/False Condition
- ClickOK.
- On theCalculationtab, create the true/false condition. Add this row to the grid:And/Or(FieldOperatorComparison TypeComparison Value)And% of Shift in Shift 2greater thanValue specified in this filter0.5
- ClickOKandDone.
- Use the calculated field,Majority of Shift Worked in Shift 2, to create the time block conditional calculation. This calculation tags the entire shift withShift 2 Premiumif the majority of the shift was worked inShift 2.
- Access theCreate Time Calculationtask.
- In theNamefield, enterShift 2 Premium Hours.
- From theCalculation Typeprompt, selectTime Block Conditional Calculation.
- ClickOK.
- On theGeneral Optionstab, from theTime Shift Conditionsprompt, selectMajority of Shift Worked in Shift 2.
- In theResultssection, from theAdd Tagsprompt, create aShift 2 Premiumtime calculation tag.
- On theGroupstab, add a row to the grid with these values:FieldValueTime Calculation GroupFull-Time Hourly WorkerEffective DateCurrent Snapshot
- ClickOK.
- Access theMaintain Time Calculation Prioritiestask to assign this calculation priority 050.
- ClickOKandDone.
Workday tags any reported time between 6:00 PM and 6:00 AM as
Shift 2
. If workers work the majority of their shift in Shift 2
, they receive a Shift 2 Premium
for their entire shift.