Hi guys, hope you're having a good morning!
I have been tasked to create a spreadsheet for a company that will distribute a pool income of tips to a number of bartenders based on the hours they worked. For instance, if the entire staff of bartenders made $215 of tips in one night and there were 3 bartenders working that night (bartender #1 - worked 3 hours, Bartender #2 - worked 4 hours, bartender #3 - worked 6 hours), what excel formula can I use to proportionally distribute this pool income to each bartender based on the hours they worked?
All the help is greatly appreciated. Please ask any questions if I need to clarify anything. Thank you in advance,
Michael
Bookmarks