You can write a formula to calculate absence duration automatically when a user enters an absence start and end date, or time. Your localization team may have written a formula, which the system will use by default. However, if you need a configured formula to take account of special work hours or shift patterns, you can create a new formula that will override the supplied one. You can create one formula for each Business Group.

Your formula must be called: BG_ABSENCE_DURATION. You must select the formula type QuickPaint.

The formula inputs must be:

• days_or_hours (units for the duration: D or H)

• time_start, time_end

• date_start, date_end

The formula outputs must be:

• duration (the calculated value or FAILED)

• invalid_msg (optional - an error message name)

Use the supplied example formula (TEMPLATE_ABSENCE_DURATION) as the basis for your formulas.