Hello fellow QLIK users,
I have to report on the actual amount of time it takes to resolve a problem from the time it is submitted to the time it is closed. This could be over a number of days, however each working day consists of 10hrs 08:00 - 18:00.
Any ticket submitted after 18:00 when the desk closes is considered as coming in the next day. Submissions made on a Saturday or Sunday are considered as coming in on the next working day.
An example would be:
Submitted Mon 9th Jan @ 10:24:09 / Closed on Thursday 12th Jan @ 10:20:07 - total time taken would equal 29:55:58 using the following Excel formula
=(NETWORKDAYS(Submission D&T, Closed D&T, Holidays)-1)*(18:00-08:00)
+IF(NETWORKDAYS(Closed D&T ,Closed D&T),MEDIAN(MOD(Closed D&T,1),18:00,08:00),18:00)
-MEDIAN(NETWORKDAYS(Submission D&T, Submission D&T)*MOD(Submission D&T,1), 18:00,08:00)
If any one can give an insight on how to achieve the above in QLIK it would be gratefully revieved.
Many thanks,
David
