Examples of Absence Entitlement Calculations Based on Working and Calendar Days for Fixed and Flexible Hours

One moment please...

The following are formulas adopted in absence entitlement calculations with scenarios that can help you understand the calculations better.

Entitlement calculation in days based on working days

Yearly Entitlement

Resource’s total working days in a year/division’s total working days in a year * yearly entitlement

For example:

Gerard works from Monday to Thursday for 8 hours per day, but on Friday, he works for 4 hours. His entitlement is 30 days per annum. The calculation is as follows: 261/261 * 30 = 30 days per annum.

Monthly Entitlement

Yearly entitlement/12

For example:

Gerard’s company generates entitlement on a monthly basis. Therefore, the entitlement generated for Gerard is 2.5 days per month. The calculation is as follows: 30/12 = 2.5 days.

If Gerard works for less than a year and decides to leave the company on 22 December 2009, then the entitlement generated is 1.74 days per month. The calculation is as follows: 16/23 * 2.5 = 1.74 days.

Note: Resource total working days and division total working days in a year may vary from year to year, and working days will not include off days (annual leave, medical leave, etc.) and rest days (public holidays and designated off days by the company such as Saturday/Sunday)defined at the resource or division schedule.

Entitlement calculation in days based on calendar days

Yearly Entitlement

Resource’s total working days in a year/calendar year * yearly entitlement

For example:

Hugh works from Monday to Thursday for 8 hours per day, but on Friday, he works for 4 hours. His entitlement is 21.45 days per annum. The calculation is as follows: 261/365 * 30 = 21.45 per annum.

Monthly Entitlement

Yearly entitlement/12

For example:

Hugh’s company generates entitlement on a monthly basis. Therefore, the entitlement generated for Gerard is 1.79 days per month. The calculation is as follows: 21.45/12 = 1.79 days per month.

If Hugh works for less than a year and decides to leave the company on 22 December 2009, then the entitlement generated is 0.92 days per month. The calculation is as follows: 16/31 * 1.79 = 0.92 days.

Absence deductions for entitlement calculation based on working days

Calculated in days

Number of hours taken based on a resource’s schedule/number of hours worked based on a resource’s schedule.

For example:

Alex's division schedule and resource schedule as follows:

Division's Schedule - 8 hours per day:

Days

Day Type

No. of Hours

Hours

Hours

Monday

Normal

8

08:00 - 12:00

13:00 - 17:00

Tuesday

Normal

8

08:00 - 12:00

13:00 - 17:00

Wednesday

Normal

8

08:00 - 12:00

13:00 - 17:00

Thursday

Normal

8

08:00 - 12:00

13:00 - 17:00

Friday

Normal

8

08:00 - 12:00

13:00 - 17:00

Saturday

Off day

0

00:00 - 00:00

00:00 - 00:00

Sunday

Rest day

0

00:00 - 00:00

00:00 - 00:00

Resource's Schedule:

Days

Day Type

No. of Hours

Hours

Hours

Monday

Normal

8

08:00 - 12:00

13:00 - 17:00

Tuesday

Normal

8

08:00 - 12:00

13:00 - 17:00

Wednesday

Normal

4

08:00 - 12:00

13:00 - 17:00

Thursday

Normal

8

08:00 - 12:00

13:00 - 17:00

Friday

Off day

4

08:00 - 12:00

00:00 - 00:00

Saturday

Off day

0

00:00 - 00:00

00:00 - 00:00

Sunday

Rest day

0

00:00 - 00:00

00:00 - 00:00

Alex applies for leave from 10:00 a.m. to 12:00 p.m. on a Wednesday. The system will deduct 0.5 days from his absence entitlement. The absence deduction for Wednesday 10.00 am to 12.00 pm (shown in days) is as follows: 2/4 = 0.5 days.

Calculated in hours

Absences deduction calculated in days * division’s hour per day

For example:

Alex applies for leave from 10:00 a.m. to 12:00 p.m. on a Wednesday. The system will deduct 0.5 days from his absence entitlement. The absence deduction for Wednesday 10.00 am to 12.00 pm (shown in hours) is as follows: 0.5 * 8 = 4 hours.

Absence deductions for entitlement calculation based on calendar days

If a request is created on the resource’s off day (non-work day) or rest day (a fixed and designated non-work day by the country or company), the absence deduction is 1 day. Absence deductions that fall on a public holiday will be based on the settings at the division card.

For example:

Alex's division schedule and resource schedule as follows:

Division's Schedule - 8 hours per day:

Days

Day Type

No. of Hours

Hours

Hours

Monday

Normal

8

08:00 - 12:00

13:00 - 17:00

Tuesday

Normal

8

08:00 - 12:00

13:00 - 17:00

Wednesday

Normal

8

08:00 - 12:00

13:00 - 17:00

Thursday

Normal

8

08:00 - 12:00

13:00 - 17:00

Friday

Normal

8

08:00 - 12:00

13:00 - 17:00

Saturday

Off day

0

00:00 - 00:00

00:00 - 00:00

Sunday

Rest day

0

00:00 - 00:00

00:00 - 00:00

Resource's Schedule:

Days

Day Type

No. of Hours

Hours

Hours

Monday

Normal

8

08:00 - 12:00

13:00 - 17:00

Tuesday

Normal

8

08:00 - 12:00

13:00 - 17:00

Wednesday

Normal

8

08:00 - 12:00

13:00 - 17:00

Thursday

Normal

8

08:00 - 12:00

13:00 - 17:00

Friday

Off day

4

08:00 - 12:00

00:00 - 00:00

Saturday

Off day

0

00:00 - 00:00

00:00 - 00:00

Sunday

Rest day

0

00:00 - 00:00

00:00 - 00:00

Calculated in days

Alex applies for leave from 10:00 a.m. to 12:00 p.m. on a Wednesday. The system will deduct 0.5 days from his absence entitlement. The absence deduction for Wednesday 10.00 am to 12.00 pm (shown in days) is as follows: 2/4 = 0.5 days.

Calculated in hours

Alex applies for leave from 10:00 a.m. to 12:00 p.m. on a Wednesday. The system will deduct 0.5 days from his absence entitlement. The absence deduction for Wednesday 10.00 am to 12.00 pm (shown in days) is as follows: 0.5 * 8 = 4 hours.

Division card was set to exclude public holidays

Calculated in days - excluding public holidays

Alex applies for leave from Wednesday to Friday and Thursday is a public holiday, The absence deduction excluding public holidays (shown in days) is as follows:

= 8 /8 + 0 + 1

= 1 + 0 + 1

= 2 days

Calculated in hours - excluding public holidays

Alex applies for leave from Wednesday to Friday and Thursday is a public holiday, The absence deduction excluding public holidays (shown in hours) is as follows: 2 * 8 = 16 hours.

Calculated in days - including public holidays

Alex applies for leave from Wednesday to Friday and Thursday is a public holiday, The absence deduction including public holidays (shown in days) is as follows:

= 8 /8 + 1 + 1

= 1 + 1 + 1

= 3 days

Calculated in hours - including public holidays

Alex applies for leave from Wednesday to Friday and Thursday is a public holiday, The absence deduction including public holidays (shown in hours) is as follows: 3 * 8 = 24 hours.