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


 279x       Filetype XLSX       File size 0.02 MB       Source: www.strath.ac.uk


File: Time Calculation In Excel Sheet 46611 | Annual Leave Calculator
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 ...

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 guidance leave calculators to ensure consistent application of annual and public holiday entitlements through the university following have been prepared each has a different purpose which is briefly explained below if you any queries regarding please contact humanresources strathacuk or your normal hr team contacts new starts part time workers change in hours leavers ndash calculator this should be used calculate entitlement for staff members who work their during year start term contract note when calculating information entered into must only include active weeks within working pattern calculation completed period member rsquo s startschange hoursleaverspart timeannual name oracle no grade these dates show first last day enter full days date take effect leaving ddmmyyyy average weekly before after changealways remember round figure up nearest half hour ie would rounded total yearalways line manager signature employee...

no reviews yet
Please Login to review.