Our Change Manager wants a CABI report on the average time taken for an approval task to be completed. I worked out the query required, but then realised the "Actual Duration" field does not take into account the Workshift. So the results are ruined by non-office hours.
We are using SDM 12.9 CUM1 and CABI XI 3.1 SP7
Any ideas on this ?