If anyone could help it would be greatly appreciated. I like most have to fill in a time sheet each week and would like to automate it as best possible.

I have managed to find a formula on the net which will calculate eight hours then carry the remainder over but this is for the whole day and doesn't work with multiple jobs per day.

Here is a picture of one day on my timesheet:
Please Login or Register  to view this content.
Copy of time sheet : Timesheet.zip

My working hours are 8 per day any hours over are over time, travel is included. As you can see when i reach 8 hour the over time is carried over to the 1.5 column.??

This is what I currently have:

For eight hours =IF(24*(B2-A2)>8,8,24*(B2-A2))

For Overtime = =IF(24*(B2-A2)>8,24*(B2-A2)-8,"")