Help with multiple if statements

[Martin Burroughs]

What I want to do if quite easy using a calculator and my brain but I'm not getting the and statements correct. Can anyone assist?
The scenario is a simple labour hours calculator. An employee gets single time for up to 40 hours regardless of the day of the week that the hours are worked. Normal shift pattern is 4 x 10 hours Monday to Friday. If they do more than the 40 hours, they can get up to 2 hours per day at time + 1/3 and after 12 hours, they start to get time + 1/2. If they work Fridays or Saturdays and have worked at least 40 hours, they start to get time + 1/2 and for Sundays, it's double time. All that said, my first step is to calculate the hours at single time, first by reference to total hours worked. For simplicity's sake, I'll concentrate on Monday and if I get the syntax right, I can move on to Tuesday, etc.

In my spreadsheet I have the following:
A1 Actual hours Mon-Thu variable
B1 Total hours Mon-Sun variable
C1 Actual hours Mon variable
D1 Normal shift hours Monday 10
E1 Normal shift hours week 40
F1 Bonus hours (1+1/3 Mon to Thur) 2
G1 Calculation Monday hours at single time
H1 Calculation Monday hours at time + 1/3
I1 Calculation Monday hours at time + 1/2
I've put in the fixed values where applicable and just want to be able to split the total hours for Monday based on the rules in cells G1 to I1.

Thanks in advance.

[TMS]

Very detailed explanation but what would really help is a sample workbook with some typical data indicating what your calculator would give you (and how you worked that out).

A sample workbook might generate more input.


To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook. Don't upload a picture when you have a workbook question. None of us is inclined to recreate your data. Upload the workbook and manually add an 'after' situation so that we can see what you expect. In addition clearly explain how you get the results..
To attach a file to your post, you need to be using the main 'New Post' or 'New Thread' page and not 'Quick Reply'.
To use the main 'New Post' page, click the 'Post Reply' button in the relevant thread.

On this page, below the message box, you will find a button labelled 'Manage Attachments'.
Clicking this button will open a new window for uploading attachments.

You can upload an attachment either from your computer or from another URL by using the appropriate box on this page.
Alternatively you can click the Attachment Icon to open this page.

To upload a file from your computer, click the 'Browse' button and locate the file.

To upload a file from another URL, enter the full URL for the file in the second box on this page.
Once you have completed one of the boxes, click 'Upload'.

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.