If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
hr worksheet counting days missed
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? |
#2
|
|||
|
|||
hr worksheet counting days missed
You would need to give us more, a lot more, detail on how an employee sheet
is laid out. -- HTH Bob "Tina" wrote in message ... 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? |
#3
|
|||
|
|||
hr worksheet counting days missed
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. |
Thread Tools | |
Display Modes | |
|
|