Im trying to set up a holiday accrual worksheet for my employees, so that i
can tell at a glance how much holiday they have left.

basicaly, employees acrue holiday entitlement for every hour they work upto
their contracted hours per calendar month.

after each employees name, i have a box which shows what their contracted
hours are. how do i get excel to refer to this figure and use it as the
maximum when determining the amount of hours worked in any particlular
month?

Cheers!

steve