Help - Creating Tip Pooling Worksheet


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

Advertisements

Joined
May 15, 2019
Messages
1
Reaction score
0
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top