Identify Shift Work Hours and Meal Break Requirements

The ORA_WFM_ACR_SHIFT_DURATIONS_AP formula, which uses array processing, calculates a shift's work duration and the number of meal breaks according to the web clock buttons properties. It then evaluates whether the worker worked the expected duration and took the expected breaks.

Use this fast formula, for example, to display an appropriately configured attestation that asks the worker why they didn't take the expected meal breaks.

Parameters

Name Type Description
SHIFT_WORK_DURATION Fixed number Duration worked for the shift defined by the start and end set of the related web clock buttons, such as Clock In and Clock Out.
Minimum number of meal breaks Fixed number Number of meal breaks taken during the shift. A meal break is defined by the start and end set of the related web clock buttons, such as Meal In and Meal Out.
Work Payroll Time Types Fixed text List of semicolon-separated payroll time types to use to identify the time entries to use to calculate the work duration of a shift.
Meal Break Payroll Time Types Fixed text List of semicolon-separated payroll time types to use to identify time entries to use to calculate the number of meal breaks taken.

Function

If the calculated shift work duration is greater than or equal to the value of the SHIFT_WORK_DURATION parameter and the number of meal breaks is less than the value of the Minimum number of meal breaks parameter, then use the time entry for processing.

Examples

The time category is used in an attestation set. The worker sees an attestation when they didn’t take enough meal breaks based on their shift work duration.

Web clock buttons configuration:

Clock Event Time Attribute Default Time Attribute Value
Clock In Clock Property Start Shift
Meal In Clock Property Meal Start
Meal Out Clock Property Meal End
Clock Out Clock Property Shift End

Fast formula parameter values:

  • Shift Work Duration: 10h
  • Number of Meal Breaks: 2
  • Work Payroll Time Types: Regular Hours

Web clock events and corresponding time entries:

Day 1 Day 2 Day 3 Day 4 Day 5 Day 6 Day 7
Web Clock Events

Clock In: 8:00a

Meal In: 12:00p

Meal Out: 12:30p

Clock Out: 5:00p

Clock In: 8:00a

Meal In: 12:00p

Meal Out: 12:30p

Clock Out: 7:00p

NA

Clock In: 8:00a

Meal In: 11:00a

Meal Out: 11:30a

Meal In: 3:00p

Meal Out: 3:30p

Clock Out: 7:30p

Clock In: 8:00a

Meal In: 12:00p

Meal Out: 12:30p

Clock Out: 5:00p

Clock In: 8:00a

Meal In: 11:00a

Meal Out: 11:30a

Meal In: 3:00p

Meal Out: 3:30p

Clock Out: 6:00p

NA
Time Entries

8:00a to12:00p

12:30p to 5:00p

8:00a to12:00p

12:30p to 7:00p

NA

8:0 a to 11:00a

11:30p to 3:00p

3:30p to 7:30p

8:00a to 12:00p

12:30p to 5:00p

8:00a to 11:00a

11:30p to 3:00p

3:30p to 6:00p

NA
Work duration 8h30m 10h30m NA 10h30m 8h30m 8h NA
Meal breaks 1 1 NA 2 1 2 NA
NA NA
Attestation None Meal Break question NA None None None NA