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

    Times calculation

    Sabine Böning

      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

      1. 01.04.2016 06:20

      02:15

      100

      XXX

      Erika Mustermann

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