formula to return # hrs after time a day/date condition

Is there a way that i can populate an outcome that calculates the number of hours that fall within certain time frames dependant on the day of the week.

IE.

A1=0400 hrs
A2=2230 hrs

I need to calculate the number of hours that are in the range 6am to 6pm and 6pm to 6am and if those hours are more than 8, hrs 9 & 10 are reported in another colum, and more than 10 are reported inanother. Basically, you can only work 8 hors in any shift, and after that, the next 2 hours are at a different rate of pay, and the 3rd or more at another higher rate of pay.


Doe this make sence?

So for the above hour the report would look like this:

Hrs between 6am-6pm = 12, 8 at ordinary time, 2 at next rate and 2 at the final rate
Hrs between 6pm and 6am = 6.5hrs

Then i hope it can identify whech hours are on which days, i.e. hours that fall within a saturday or sunday (after midnight) are reported. i.e

A1= 16:00 (friday)
A2= 06:00 (saturday)

Hrs between 6am-6pm = 2, 2 at ordinary time, 0 at next rate and 0 at the final rate
Hrs between 6pm and 6am = 6hrs x friday rates, 6 hrs saturday rates.

Please post a sample workbook so that we don't have to try to create our own by copy/paste from a text file.