Prev: How do I set up a botton on Excel 2003 to go to the next sheet?
Next: Linking data from one worksheet to another...
From: Tina on 5 May 2010 14:30
I currently track employee time for the purpose of tracking vacation time.
Now my bosses would like to add a function that will alert if an employee is
absent more than three times in 180 days. I am trying to figure out how to
start. The data is in the workbook (each employee on a seperate sheet) and i
currently have a summary sheet for the vacation time. I need one for the
time missed within 180 days how do I start?
From: Bob Phillips on 5 May 2010 14:38
You would need to give us more, a lot more, detail on how an employee sheet
is laid out.

--

HTH

Bob

"Tina" <Tina(a)discussions.microsoft.com> wrote in message
news:5D689238-BA05-46C7-8EEF-A1D7C822F3E3(a)microsoft.com...
>I currently track employee time for the purpose of tracking vacation time.
> Now my bosses would like to add a function that will alert if an employee
> is
> absent more than three times in 180 days. I am trying to figure out how
> to
> start. The data is in the workbook (each employee on a seperate sheet)
> and i
> currently have a summary sheet for the vacation time. I need one for the
> time missed within 180 days how do I start?


From: trip_to_tokyo on 5 May 2010 15:10
Why not just add a column for ABSENT and place a 1 in that column each time
the employee is off? Total / sub total as required.

If my comments have helped please hit Yes.

Thanks.


 | 
Pages: 1
Prev: How do I set up a botton on Excel 2003 to go to the next sheet?
Next: Linking data from one worksheet to another...