Hello
I'm asked to calculate the time spent for resolving a problem.
Therefore, i use the following formula:
numberVar dur := datediff ("s",{ROOTCAUSEM1.OPEN_TIME}, {ROOTCAUSEM1.CLOSE_TIME}-
datediff ("ww", {ROOTCAUSEM1.OPEN_TIME},{ROOTCAUSEM1.CLOSE_TIME},crsaturday) -
datediff ("ww"...