I need to develop a tracking spreadshet for (18 employees) that will calculate accruing annual leave based on the following:
Employees are entittled 1 hour leave for every 16.4 hours worked ( 12 months cycle)


I need to be able to deduct annual leave used. Need suggestion for layout , formula etc



Thanks