# Help - Creating Tip Pooling Worksheet

A

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!

C

#### 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