Hi developers,

the quiz is that I have four references, date and time required (dR and tR), date and time of intervention (dI and tI).

I calculate the diference between them (dDif = dI - dR and tDif = tI and tR), so now I know how many days (dDif) and time (tDif) wasted from request to intervention separately.

I calculate now the diference between them creating datetimes (dTotal := CREATEDATETIME(dR,tR) - CREATEDATETIME(dI,tI). Now I got the duration between request and intervention, for example 1 day, 20 hours and 15 minutes.

But the problem is that now I need to subtract for each day (dDif) 13 hours. All this is to calculate quality times with customers, the subtract is because I don’t have to include the time the corporation is closed (13 hours per day).

Any suggestion? [:S]

Thanks !!!