Docstoc

Annual Leave and holidays - University of Nottingham

Document Sample
Annual Leave and holidays - University of Nottingham Powered By Docstoc
					Annual Leave Calculator for Part-time employees taking Maternity/Adoption Leave


To use this calculator all you need to do is complete the yellow manual entry cells, the pink cells are calculated based on the yellow cells. Click on the text line for further guidance.

Calculated field (no entry required) based on manual entries of manager-Note until manual entries completed the calculations may not make sense
Manual entry required to be input by manager e.g.. Hours of work, click on text for further guidance
Useful web links
http://www.nottingham.ac.uk/staff/bankhol.phtml#bank
                                                                                                                                                               Accrual Per hour worked
Days worked per week prior to maternity leave
Contracted hours at point of taking maternity leave
Full time hours for the post
Hours per year                                                                                                                                          0.00
Annual leave in days per year (Levels1, 2 or 3 =25 days, Level 4 & above =30 days)
Annual leave in hours per year                                                                                                                          0.00     #DIV/0!
Bank & University holidays per year in hours                                                                                                            0.00     #DIV/0!

ANNUAL LEAVE YEAR ON COMMENCING MATERNITY LEAVE

Number of weeks worked before commencing maternity leave
Hours worked                                                                                                                                           0.00
Annual leave in hours accrued                                                                                                                       #DIV/0!
Bank/University accrued in hours                                                                                                                    #DIV/0!
Sub total of hours leave                                                                                                                            #DIV/0!

Number of Maternity Leave weeks taken in leave year of starting maternity leave
Annual Hours accrued during maternity leave                                                                                                         #DIV/0!

Total annual leave hours in year of starting maternity leave                                                                                        #DIV/0!
Days annual leave taken (including bank/University holidays see web link above) in year of starting maternity leave
Hours leave (including bank/University holidays) already taken in year of starting maternity leave                                                  #DIV/0!
Total hours annual leave remaining in year of starting maternity leave                                                                              #DIV/0!
Days annual leave remaining in year of starting maternity leave                                                                                     #DIV/0!

ANNUAL LEAVE YEAR ON RETURNING FROM MATERNITY LEAVE IF MATERNITY DATES SPANS 2 LEAVE YEARS

Number of weeks to be worked after returning to work from maternity leave in relevant leave year
Contracted hours at point of returning from maternity leave
Days worked per week on return from maternity leave
Hours worked                                                                                                                                           0.00
Annual leave in hours accrued                                                                                                                       #DIV/0!
Bank/University accrued in hours                                                                                                                    #DIV/0!
Sub total of hours leave                                                                                                                            #DIV/0!

Number of Maternity Leave weeks in leave year on returning to work
Annual Hours accrued on maternity leave                                                                                                             #DIV/0!

Total annual leave hours in year of returning from maternity leave                                                                           #DIV/0!
Days annual leave remaining in year of returning from maternity leave (including bank/University holidays to be taken)                       #DIV/0!
In practical terms the figure above means that from the date of returning to work the employee can take this many days annual leave which includes all the bank holidays and University holidays.
They should then take away form this figure the number of bank and University holidays that occur during their work pattern of X days per week.
The figure that remains is the number of days annual leave she can chose to take whenever before the end of the current leave year.

				
DOCUMENT INFO