Timesheet Differential Trauma..

Hi,

This is my first post in this forum and I've got myself doozy of a problem

I'm busy recreating our overtime claim form and had some success with the calculation of breaks from overall time.
The problem i'm now facing is how to calculate hours on adjusted rate..
I have an idea what to with Min/max to determine a time, I hit a brick wall when a shift starts in normal time, crosses all of ajusted rate, and ends in normal time again.

Attached is a copy of the test sheet - I have tried a few approaches as some of the red values show, and some of the test values I randomly have on the right-hand side outside of the sheet.


The conditions are:

Automatically deduct 30 minutes for every 6hrs+ worked (mandatory break) per time in/out. (working)
Show total hours worked below each day (working)
Calculate adjusted rate for hours worked between 8pm-6am (NOT WORKING)

Same conditions apply for weekend work

-----------

I wouldn't be asking is I hadn't searched google and numerous excel-related sites for an obvious solution. A lot of the formulas used have been based on answers found elsewehere but i have reached an impasse with my current knowledge,
Where possible, I'd like to avoid using VBA,
It really is driving me to distraction, so any help or pointers in the right direction would be appreciated.