jagomart
digital resources
picture1_Spreadsheet Calculator 46266 | Form Annual Leave Calculator 2022 23 Esr Frm 141


 250x       Filetype XLSX       File size 0.02 MB       Source: peoplefirst.nhsbt.nhs.uk


File: Spreadsheet Calculator 46266 | Form Annual Leave Calculator 2022 23 Esr Frm 141
sheet 1 guidance guidance check you are using the calculator for the correct leave year complete the fields in blue at the beginning of the year as changes occur enter ...

icon picture XLSX Filetype Excel XLSX | Posted on 18 Aug 2022 | 3 years ago
Partial file snippet.
Sheet 1: Guidance
Guidance
Check you are using the calculator for the correct leave year.
Complete the fields in blue at the beginning of the year
As changes occur enter them in the fields in green
For changes in leave entitlement enter the anniversary of 5 or 10 year service
For changes in contract hours enter the date of change (as advised to NHSBT Pay Support)
Fields in grey are automatically populated/calculated
If you leave complete the leave taken field and email with the terminaton form to NHSBT Pay Support - terminations





Annual Leave (full time equivalent)
Continuous Service exc Bank Hols inc Bank Hols (2022/23) Equivalent calendar days entitlement
< 5 202.50 270.00 27
5 - 10 217.50 285.00 29
> 10 247.50 315.00 33





Bank holidays (full time equivalent)

Leave year Number of hours Number of days

2016/2017* 45 6

2017/2018** 67.5 9

2018/2019** 52.5 7

2019/2020 60 8

2020/2021 60 8

2021/2022 60 8

2022/2023 67.5 9 additional BH - Jubilee





* difference is due to the way Easter fell in 2016
** difference is due to the way Easter falls in 2018
also note that 2020 is a leap year

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

...Sheet guidance check you are using the calculator for correct leave year complete fields in blue at beginning of as changes occur enter them green entitlement anniversary or service contract hours date change advised to nhsbt pay support grey automatically populatedcalculated if taken field and email with terminaton form terminations annual full time equivalent continuous exc bank hols inc calendar days lt gt holidays number additional bh jubilee difference is due way easter fell falls also note that a leap...

no reviews yet
Please Login to review.