Hello everybody,
I need your expertise help.
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.
Thanks in Advanced!!!
