Hi guys, trying to get some help using excel 2010 and to see if what i am looking to do is even possible.
I have a schedule workbook with a 14 day rotation of employees divided by employee role, start/finish time and day of the week.
I am trying to compile and divide all shift times with how many employees are working at any given time and displaying the role within a period.
For example:
Monday - 6-2 - 2 seniors / 8-4 - 1 senior, 3 frontlines / 10-6 - 1 senior, 4 frontlines - etc
Is this possible? Where can i can started as i am trying to find ideas or help on the net but can't seem to find anything specific to what i am trying to achieve and i found these board!
Here is an example of the book, names blanked out:
book_zpskbrl14eh.png
Is this possible? Any help or points in the right direction appreciated!
Bookmarks