Timesheet, hours worked with multiple varriables...

Hi Biozombie,

I've had a bust day today, and unable to deal with your problem. I will look tomorrow.

Regards, David

Hello again Biozombie,

This is a quite complex issue!

As requested, I have provided you with some code, BUT IT IS INCOMPLETE! The main area where more work is needed is where you hit the 40 hour mark - there may be problems in splitting the hours between overtime and double time.
The code I have entered provides the answers you expected, but I am mindful of the transitions, and if I had more time I would attend to it.

You did say you are keen to learn, so hopefully you can follow what I am trying to do.

biozombie.xlsx

First of all, I added a new row showing the accumulated hours - this makes the formulas a lot shorter!

Basically, each of the three formulas in cells C14:C16 contain a formula which can be copied across. The first half of the formula (before the PLUS sign) is calculating the Shop Hours and Travel time, the second half tries to get the rest. (this second half may need more work).

Please have a look at what I've done and see how you go.

I hope this helps, please let me know!

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.