jagomart
digital resources
picture1_Time Calculation In Excel Sheet 46424 | Annual Leave Calculator


 205x       Filetype XLSX       File size 0.11 MB       Source: www.ed.ac.uk


File: Time Calculation In Excel Sheet 46424 | Annual Leave Calculator
sheet 1 menu amp guidance annual leave calculator general information who can use this calculator the calculator can be used for full and parttime staff working a full year it ...

icon picture XLSX Filetype Excel XLSX | Posted on 18 Aug 2022 | 3 years ago
Partial file snippet.
Sheet 1: Guidance
Leave Calculators












To ensure consistent application of annual leave and public holiday entitlements through the University, the following calculators have been prepared. Each has a different purpose which is briefly explained below. If you have any queries regarding the calculators below, please contact humanresources@strath.ac.uk or through your normal HR team contacts.








New Starts, Part Time workers, Change in Hours or Leavers – Leave Calculator








This calculator should be used to calculate annual leave entitlement for staff members who work part time, change their hours during the leave year, start during the leave year, or is leave during the leave year.








Term Time Contract - Leave Calculator









This calculator should be used to calculate the annual leave and public holiday entitlement for staff members who have a term time contract. Please note when calculating leave entitlement, the information entered into the calculator must only include active weeks within the working pattern. A new calculation should be completed for each active period within the staff member’s working pattern.








































Sheet 2: Calculator 1
New Starts/Change in hours/Leavers/Part Time
Annual Leave Calculator




Staff member name
Oracle No.
Grade




10/1/2021 These dates must show the first and last day of the leave year.
9/30/2022




Enter Full Annual leave entitlement in days for the full year (days)
Enter date when new hours take effect or start date or leaving date (DD/MM/YYYY)
Enter average weekly hours before start date or date of change
Enter average weekly hours after start date or date of change




Annual Leave (Hours) to take after the date of change
Always remember to round this figure UP to the nearest half hour ie. 23.17 would be rounded up to 23.5 hours
0.00
Annual Leave (Hours) to take before the date of change
Always remember to round this figure UP to the nearest half hour ie. 23.17 would be rounded up to 23.5 hours
0.00
Total Annual Leave (hours) for the year
Always remember to round this figure UP to the nearest half hour ie. 23.17 would be rounded up to 23.5 hours
0.00




Line Manager Signature and Date




Employee Signature and Date

The words contained in this file might help you see if this file matches what you are looking for:

...Sheet menu amp guidance annual leave calculator general information who can use this the be used for full and parttime staff working a year it also those partyear ie fixed term contracts less than joining or leaving partway through is not to on annualisedfractional time changes in entitlement you will need do two separate calculations if your midyear specifically hours pattern are grade attain more years service first calculation should cover period from start of date after january up change including any carried forward second end before st december excluding must then add both totals section together revised variable weekly work different each week average calculate example per one following ndash enter due public holiday rsquo s so every nd monday that falls th would whatever day at holidays only entitled employed by university days apply did until likewise prorated note having difficulty viewing increasedecrease size page adjusting slider bottom right hand corner inputs outputs com...

no reviews yet
Please Login to review.