Hey guys, I have another question with my scheduling book for my non-profit company.
Right now it's set up so Clients are in Column A and the staff for each client is listed in columns B through H.
Next to that is Clients in Column J and the hours they are in program. So the Staff are listed again in Column S and the formula in T adds up their names corresponding to the hours. This all works great thanks to some previous help on this forum:
http://www.excelforum.com/excel-form...om-sheet2.html
Now the new issue we have is that Staff can possibly work with multiple Clients on the same day and even though it's still a 6 hour day for example, it's counting as 12 or 18 hours.
Is there a way to stop this from happening? Like if the column Monday detects the same name multiple times, we only want it to count for one.
Even if we have to create another row/column just for the staff that have duplicate names... I have no idea what to do here.
In the attachment:
I have conditional formatting set individually for Monday - Sunday to highlight duplicate names, Right now we have Staff "Josh" on Monday working with Clients "Steve Bolhman" and "Mark Reign" Both clients are 6 hours for the day, and right now Josh is getting 12 hours instead of 6.
We also have Staff "Ray" working with Clients "Walter Thomas" and "Bethany Timms" who are both 8 hour clients, and Ray is being paid for 16 hours instead of 8.
If you need any clarifications please let me know. Thank you all for your help and time.
-Steven
Bookmarks