complicated time shift calculation

Dear members

I work from 05:30 to 17:30
I work shifts that are called 2,2,3

I will explain this
work mon, thu. Off wed, thu, work fri, sat, sun
off mon, thu. work wed, thu, off fri, sat, sun
and so on and so on

This is my work schedule

Weekdays from 05:30 to 14:30 0% 1.485 kr.
Weekdays from 00:00 to 05:30 33% 1.975 kr.
Weekdays from 14:30 to 17:15 45% 2.153 kr.
Sat & Sun from 00:00 to 17:15 45% 2.153 kr.
Overtime after 17:15 80% 2.673 kr.

What I want to be able to do is
Say for example I start at 05:00 and finish at 18:00
Then I want to be able to put in one cell 05:00
and another cell 18:00 and excel calculates this

9 hrs @ 1485 = 13365
30 min @ 1975 = 987,5
2,45 Hrs @ 2153 = 5921,4
1,45 Hrs @ 2673 = 4677,7

Can anyone help me with this

all the best
Eidur

What do the percentages mean?

Row\Col	A	B	C	D	E	F	G	H	I
1			Mon	1	1	1		1
2			Tue	1	1	1		1
3			Wed	1	1	1		1
4			Thu	1	1	1		1
5			Fri	1	1	1		1
6			Sat				1	1
7			Sun				1	1
8			TimeBeg	0:00	5:30	14:30	0:00	17:15
9			TimeEnd	5:30	14:30	17:15	17:15	24:00
10			Rate	1485	1975	2153	2153	2673
11	Date	In	Out	Time	Time	Time	Time	Time	Pay
12	Mon 02-Mar-2015	5:30	17:30	00:00	09:00	02:45		00:15	24,364
13	Tue 03-Mar-2015	4:30	17:30	01:00	09:00	02:45		00:15	25,849
14	Wed 04-Mar-2015								-
15	Thu 05-Mar-2015								-
16	Fri 06-Mar-2015	5:30	17:30				11:45	00:15	25,966
17	Sat 07-Mar-2015	5:30	20:00				11:45	02:45	32,649
18	Sun 08-Mar-2015	5:30	17:30	00:00	09:00	02:45		00:15	24,364
19	Mon 09-Mar-2015								-
20	Tue 10-Mar-2015								-
21	Wed 11-Mar-2015	5:30	17:30	00:00	09:00	02:45		00:15	24,364
22	Thu 12-Mar-2015	5:30	17:30	00:00	09:00	02:45		00:15	24,364
23	Fri 13-Mar-2015								-
24	Sat 14-Mar-2015								-
25	Sun 15-Mar-2015								-

In D12 and copy right and down,

=IF(INDEX(D$1:D$7, WEEKDAY($A12)) * (COUNT($B12:$C12)=2), MAX(0, MIN($C12, D$9) - MAX($B12, D$8)), "")

In I12 and copy down:

=24 * SUMPRODUCT(D$10:H$10, D12:H12)

See attached.

You're welcome.