We schedule approx. 30 employees Monday to Sunday
We use a simple spreadsheet, with the working employee's number under the scheduled time for a 2 week period. This is a simple example:
January 06:30 07:00 09:00 10:00 12:00 14:00
1 100 101 102 103 104 105
2 107 109 101 110 104 105
3 100 103 104 111 105 112
etc. for 14 days.
I would like to display how many times an employee's number has been entered in the 14 day period.
Example:
100 =2
101 =2
103 =2
104 =3
105 =3
etc.
also, see attached file.
Thanks
Bookmarks