Have a google sheet that keeps track of employees percentage of tips earned on every bill from a total entered every day.
For those that work every day, this is easy and have the formulas in place but I have employees that work Wednesday to Saturday which changes the percentage for everyone to give the others their fair share.
I created different formulas depending on the days of the week but this means I have to manually do this every month when i need a new sheet. I need a breakdown like this. Sundays it is 50/50 between 2 employees. Monday and Tuesdays it is 35/35 and 15/15 and Wed to Saturday it is 30/30,15/15 and 10%.
Can someone help me out?