Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Payroll
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Payroll
"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? -- Hope this helps. If it does, please click the Yes button. Thanks in advance for your feedback. Gary Brown "Squidgee" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need payroll | Excel Discussion (Misc queries) | |||
how do i set up payroll | Excel Worksheet Functions | |||
Payroll | Excel Discussion (Misc queries) | |||
Adding payroll stubs payroll calculator | New Users to Excel | |||
Payroll | Excel Discussion (Misc queries) |