Weekly Hours Weeks Full Holiday Pro Rata Holiday Full Bank Holiday Pro Rata Bank Weekly Annual Annual Monthly
Daily Hours Worked Annual Hours FTE Hours (for Salary (for calc)
Worked Worked Entitlement Entitlement Entitlement Holiday Enitltment Salary Salary
RL)
37 7.4 39 1443 32 23.934 10 7.479 86.84% 32.13 £11,454.00 £9,947.07 £828.92
Calculated Cells Wks Pro Rata 45.28
Data Input Cells
NEW TERM TIMER FORMULA
Based on --> Weeks per Year 39 Hrs Per wk 37 Leave Entitlement 32
Annual
Term Hours (Based Salary (for Annual Monthly
AL Entitlement Total FT Hrs AL Hrs BH Hrs Available on FT) %'age of FTE Hrs Wks to Be Paid FTE calc) Salary Salary
32 1929.285714 236.8 74 1618.485714 1443 89.157% 46.49 32.99 £ 11,454.00 £10,212.09 £851.01
Input Cells