Time Calculation In Excel Sheet 46424 | Annual Leave Calculator

238x 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 ...

Filetype Excel XLSX | Posted on 18 Aug 2022 | 3 years ago

Download

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...

Related files

Share

Help

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.

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

Related files

Share

Share to social media

Help

Login Area