Help - Creating Tip Pooling Worksheet

  • Thread starter Thread starter adammiy
  • Start date Start date
A

adammiy

Hi everyone!

Trying to create a tipping worksheet.

I found one, but I'd have to pay.

Can someone assist me in making somehting as complicating as the link below?

http://www.restaurantowner.com/public/1398.cfm

The key parts is trying to find out and allocate the % of tips based on hours worked.

For example:
Jon works 5 hours
Jane works 3 hours
Mike works 1 hour

What would be the % of tip for each person based on the hours worked.

Thanks a lot!
 
Hi,

Am Sun, 21 Oct 2012 12:55:05 -0700 (PDT) schrieb (e-mail address removed):
The key parts is trying to find out and allocate the % of tips based on hours worked.

For example:
Jon works 5 hours
Jane works 3 hours
Mike works 1 hour
Click to expand...

9 hours are 100%. 5 hours will be:
5/9 = 55,56%.
The names in A1:A3, the hours in B1:B3, then in C1:
=B1/SUM($B$1:$B$3) and copy down.


Regards
Claus Busch
 
Claus Busch said:
Hi,

Am Sun, 21 Oct 2012 12:55:05 -0700 (PDT) schrieb (e-mail address removed):


9 hours are 100%. 5 hours will be:
5/9 = 55,56%.
The names in A1:A3, the hours in B1:B3, then in C1:
=B1/SUM($B$1:$B$3) and copy down.


Regards
Claus Busch
Click to expand...

Hey claus, what would be the formula if I was adding in a 4th person? Thanks
 
Back
Top