Help - Creating Tip Pooling Worksheet

[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!

 

[Claus Busch]

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

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

 

[Sconner9]

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

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