I want to calculate the cost of the Working Hours time outside of service agreement, but the service time are different from costumer to customer and also from weekday to weekday.
There are two tables:
Table A:
here are the time-information for each employee, who had worked for this customer. And also the price for this working time for this customer. Actually the total price does not include the cost outside the service time, just time*regular cost rate.
Table B:
Here are documented the service times for each customer per weekday.
Table A:
customer
employee
Start working time
Duration working time
Total Price in €
XXX
Max Mustermann
01.04.2016 06:20
02:15
100
XXX
Erika Mustermann
02.04.2016 08:00
03:15
50
Table B:
Kunde
Wochentag
Start outside service time
End outside service time
Fee in %
ABC
Mo
18:00
08:00
25
ABC
Tu
18:00
08:00
25
ABC
We
18:00
08:00
25
ABC
Th
18:00
08:00
25
ABC
Fr
18:00
08:00
25
ABC
Sa
12:00
00:00
40
ABC
So
00:00
00:00
60
Now I want to calculate the total price for fee for working time outside service time.
Because my English is really bad, I hope you will understand, what I mean and someone can help me.
