Payroll

[Squidgee]

Hi Guys

I have a spread sheet i am working on, Excel 2003

"B" "C" "D" "E"
"F"
Day Date Hours Worked Total Pay Sickness?
Thu 01/04/2010 0.00 £0.00
Fri 02/04/2010 12.00 £90.00
Sat 03/04/2010 12.00 £90.00
Sun 04/04/2010 12.00 £90.00
Mon 05/04/2010 0.00 £0.00
Tue 06/04/2010 0.00 £0.00
Wed 07/04/2010 0.00 £0.00
Thu 08/04/2010 0.00 £0.00
Fri 09/04/2010 12.00 £90.00 s
Sat 10/04/2010 12.00 £90.00
Sun 11/04/2010 12.00 £90.00
Mon 12/04/2010 0.00 £0.00
Tue 13/04/2010 0.00 £0.00
Wed 14/04/2010 0.00 £0.00
Thu 15/04/2010 0.00 £0.00
Fri 16/04/2010 12.00 £90.00
Sat 17/04/2010 12.00 £90.00
Sun 18/04/2010 12.00 £90.00
Mon 19/04/2010 0.00 £0.00
Tue 20/04/2010 0.00 £0.00
Wed 21/04/2010 0.00 £0.00
Thu 22/04/2010 0.00 £0.00
Fri 23/04/2010 12.00 £90.00
Sat 24/04/2010 12.00 £90.00
Sun 25/04/2010 12.00 £90.00
Mon 26/04/2010 0.00 £0.00
Tue 27/04/2010 0.00 £0.00
Wed 28/04/2010 0.00 £0.00
Thu 29/04/2010 0.00 £0.00
Fri 30/04/2010 12.00 £90.00
Month Summary
Toatal Hours 156.00
Total Pay £1,170.00
No. Of Sick Days 1


All is working fine, but i have run up against a problem. the formula i use
for total pay is =MIN(12,D4)*7.5+MAX(0,D4-12)*15 which works fine until the
guy works on a differnet day meaning he should get all of those hours paid @
15.00. As a by-the-way, is there a way of when he is sick and i put "s" in
column "F", for xcell to remove the hours and pay from the other 2 columns?

Thanks Guys
any help is greatfully recieved.

 

[Gary Brown]

"until the guy works on a differnet day"
What does this mean? You've got the guy working on 30 different days.
What's your rule for double-time?

 

[Pecoflyer]

Hi,

lots of good ideas at 'Working With Times Example Page
(http://www.cpearson.com/excel/overtime.htm)