Times calculation

Tue, 05 Apr 2016 11:10:06 GMT

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!!!

topic Times calculation in QlikView

Times calculation