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 :

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
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2