0 Replies Latest reply: Apr 6, 2016 2:43 AM by Sabine Böning

# Times calculation

Hello everybody,

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.