hi
wonder if you can help me?
I am (still) developing our staff timesheets. i have now been asked if it
would be possible to add a new function based on our new overtime policy. it
means that any overtime taken, should be taken within 2 months. so is anyone
able to figure out how i ask excel to delete overtime automatically so that
for example (here is when myself gets lost):

in May i do 2 hrs overtime.
by the policy i have time until end June to take this time off so excel
should zero the cell that tracks overtime in July BUT only for the hours
taken in May leaving the hours taken in June still to be used up.

does this make sense or have i managed to confuse you as well?

thanks for reading!
Resi

i am using excel 2003 on Windows XP