miraclmoore
New Member
- Joined
- Feb 20, 2004
- Messages
- 6
I have put together a spreadsheet that shows all of my associates on both shifts with all 7 days of the week. What i am doing is inputting their daily work status and i want to be able to get excel to return a number value for attendance reasons for each day of the week.
So these are the words i use:
Full Shift
Late In=1
Absent=2
Early Out=3
NC/NS=4
So if it's Tuesday and employee "A" is Absent when i type in Absent for that day i need the number 2 to automatically show up in a different column. If that same employee is late the next day and i type in Late In i need the number 1 to be added to the same column for a total of 3 points for the week so far.
Can anyone help me with this?
So these are the words i use:
Full Shift
Late In=1
Absent=2
Early Out=3
NC/NS=4
So if it's Tuesday and employee "A" is Absent when i type in Absent for that day i need the number 2 to automatically show up in a different column. If that same employee is late the next day and i type in Late In i need the number 1 to be added to the same column for a total of 3 points for the week so far.
Can anyone help me with this?