Part-time Holiday Calculator
This Part-time Holiday Calculator in Excel can automatically work out holiday entitlement for staff in the following situations:
- Casual and variable hours staff
- Full-time staff who start or join mid-year
- Fixed hours part-time staff who start or join mid-year
Product Summary
Subtly different holiday pay calculators are needed for different classes of employees and hence you will 3 different h oliday entitlement calculators covering these employee types in the excel file.
- Casual and variable hours staff holiday accrual calculator which allows you to calculate holiday entitlement based on hours worked. This is a holiday accrual calculator for casual staff and can also be used as a part-time holiday calculator for those working variable hours.
- Full-time staff (who start/join mid-year) Pro-rata Holiday Calculator which calculates holiday accrued at the point of exit or at the point of joining based on how many months remain in the calendar year.
- Fixed Hours part-time holiday calculator which calculates holiday accrued at the point of exit or at the point of joining based on how many months remain in the calendar year.
Product Details
1. Casual and variable hours part-time staff holiday accrual calculator
This holiday accrual calculator uses the 12.07% holiday accrual method to work out holiday accrued for casual and variable hours and part-time staff based on hours worked. (The standard working year is 46.4 weeks (52 weeks – 5.6 weeks statutory entitlement) and 5.6 weeks is 12.07% of 46.4 weeks. ). To use the holiday accrual calculator, simply insert hours worked over the period into the appropriate field below to calculate part time holiday entitlement based on hours worked. The variable hours part-time holiday accrual calculator allows a little more customization of your input data.
2.Full-time staff (who start/join mid-year) Pro-rata Holiday Calculator
This Full-time staff Pro-rata Holiday Calculator calculates holiday accrued at the point of exit or at the point of joining based on how many months remain in the calendar year. This can be customized: the standard holiday entitlement figure can be adjusted and you can include holiday carry over days along service entitlement days which are all automatically incorporated into your pro rata holiday calculation.
3.Fixed Hours part-time holiday calculator.
This fixed hours part-time holiday calculator will calculate holiday entitlement based on hours worked for part-time staff working fixed hours. You can modify the part-time fixed working hours figure to calculate holiday entitlement based on hours worked. If your part-time staff work variable hours then use the variable hours calculator above. Just like the full-time holiday hours calculator above this part-time holiday calculator can be customized: the standard holiday entitlement figure can be adjusted and you can include holiday carry over days along service entitlement days which are all automatically incorporated into your pro rata holiday calculation.
—————————————————————————————————————————————————————————————————————————————————————-
Part-time Holiday Calculator
This Part-time Holiday Calculator in Excel can automatically work out holiday entitlement for staff in the following situations:
- Casual and variable hours staff
- Full-time staff who start or join mid-year
- Fixed hours part-time staff who start or join mid-year
