Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Employee Tracking Schedule
I have a monthly table listing all employees names (rows) and days of month
(columns). I would like to be able to enter an alpha character, like "v" for vacation in the date column and have the number hours assigned to that letter deduct from the total number entered into the total for that person. I think I need a Lookup table and assignment to a range to make this happen, but would like some suggestions on exactly what the programming should be. Thanks! |
#2
|
|||
|
|||
I have a monthly table listing all employees names (rows) and days of
month (columns). I would like to be able to enter an alpha character, like "v" for vacation in the date column and have the number hours assigned to that letter deduct from the total number entered into the total for that person. I think I need a Lookup table and assignment to a range to make this happen, but would like some suggestions on exactly what the programming should be. Thanks! One way is suggested by the simplified example in the CSV file below. ---------------- cut here ---------------- ,"=DATE(2005,10,1)",=B1+1,=C1+1,=D1+1,Vac allowed,Vac left, John,v,,,,112,"=F2-8*COUNTIF($B2:E2,""v"")", Paul,,v,v,v,112,"=F3-8*COUNTIF($B3:E3,""v"")", George,,v,,v,168,"=F4-8*COUNTIF($B4:E4,""v"")", Ringo,,,,,168,"=F5-8*COUNTIF($B5:E5,""v"")", |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change formula for Employee Shift Schedule template | Excel Worksheet Functions | |||
Referencing a newly created worksheet | Excel Worksheet Functions | |||
Employee schedule: I want it to calculate time entered such as 11. | Excel Discussion (Misc queries) | |||
Employee Shift Schedule Excel template | Excel Discussion (Misc queries) | |||
making an employee schedule in two sheets | Excel Worksheet Functions |