Hi Biozombie,

It is difficult to provide answers because there are so many questions. The sample you provided is difficult for me to follow.

1. There is no label on row 8, but 20 in cell C8. What is this? (Perhaps ONSITE?)
2. I assume this is a time sheet for an individual! Clearly he/she could not work 20 hours in any one day.
3. Do penalty rates change if work is done at the weekend?
4. Can I restate your pay structure another way? Is this the way it works?
- An employee is paid ordinary time for hours worked in the shop, or travelling UP TO 40 hours. The next 16 hours worked are at X1.5 then DOUBLE TIME over 56 hours. HOWEVER, any on-site hours are paid at X1.5 and X2.0 for over 40 hours.
5. I assume that if an employee works 8 hours on-site early in the week, even though they are paid at X1.5, the hours are counted as ordinary hours for the purpose of calculating when overtime kicks in at 40 hours. Is this how it would work?

It would be useful if you could answer these questions, and perhaps post a new sample sheet with real values in the first few rows, and the expected values in the shaded rows where you want us to provide the formulas.


Regards,

David

If this has been of assistance, please advise. A little thanks goes a long way.
- Please click on the *Add Reputation button at the bottom of helpful responses.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

If several people have responded, when you reply please make it clear WHO you are responding
to by mentioning their name.