Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Attendance Sheet.
Imagine spreadsheet with names of all employees in coloum A. Coloums B, C,
and D are labeled Absent, Late, and Short Shift. All the rest of the coloums are by date. I need 2 things. First my companies attendance policy says that if you have more than 4 points in 90 days then bad things happen. Short sifts and late arrivals are .5 of a point and absent is 1 point. I need to have a formula that can calculate 90 days in the past and give me each employees point total from the current date. Second, i need to enter lates and short shifts by both code and time. Example is SS6 meaning that someone left 6 minutes early. How can i do this and not screw up the above formula? Any ideas? -- Clark |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Attendance Sheet.
Not clear.
What gets entered in the B, C and D columns? What gets entered under a date column? Under a date do we have a code for short-****/late/absent? Can someone be late AND have short-shift on one day? -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Clark" wrote in message ... Imagine spreadsheet with names of all employees in coloum A. Coloums B, C, and D are labeled Absent, Late, and Short Shift. All the rest of the coloums are by date. I need 2 things. First my companies attendance policy says that if you have more than 4 points in 90 days then bad things happen. Short sifts and late arrivals are .5 of a point and absent is 1 point. I need to have a formula that can calculate 90 days in the past and give me each employees point total from the current date. Second, i need to enter lates and short shifts by both code and time. Example is SS6 meaning that someone left 6 minutes early. How can i do this and not screw up the above formula? Any ideas? -- Clark |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Attendance Sheet.
B = Absent ( defined as missing an entire work day)
C = Late (defined as not being at work for the start of your shift) D = Short Shift (defined as not working an enitre shift for whatever reason except as defined in the definition for being late) Yes, it is possible to be late and have ashort shift by leaving early. The code for Absent is "A" Code for Late is "LCode for Short Shift is "SS". Does this help? -- Clark "Bernard Liengme" wrote: Not clear. What gets entered in the B, C and D columns? What gets entered under a date column? Under a date do we have a code for short-****/late/absent? Can someone be late AND have short-shift on one day? -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Clark" wrote in message ... Imagine spreadsheet with names of all employees in coloum A. Coloums B, C, and D are labeled Absent, Late, and Short Shift. All the rest of the coloums are by date. I need 2 things. First my companies attendance policy says that if you have more than 4 points in 90 days then bad things happen. Short sifts and late arrivals are .5 of a point and absent is 1 point. I need to have a formula that can calculate 90 days in the past and give me each employees point total from the current date. Second, i need to enter lates and short shifts by both code and time. Example is SS6 meaning that someone left 6 minutes early. How can i do this and not screw up the above formula? Any ideas? -- Clark |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
attendance log | New Users to Excel | |||
How can I check the "P" or "A" in the attendance sheet | Excel Worksheet Functions | |||
Help with Volunteer Attendance Sheet | Excel Discussion (Misc queries) | |||
attendance sheet | Excel Worksheet Functions | |||
attendance sheet to add time but not..... | Excel Worksheet Functions |