Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do i do this?
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 |