Calculating Time Spent in A process based on working Hours

[#1]

Hi,

     I am trying to build an application for process/workflow optimization. One of the most critical measure is related to time spent at some of process stages. This measure claculation must be precice and relfect the actual time spent. In order to reach this level of precision the calcuation should take the folloing codition when calcualtion

what we have is the start and end date of the process stage, and we need to clacuate the time spent in working hours. The claculation should consider that the employee is working from 7:30 AM untill 4:00 PM and he have a break from 11:30 AM and 1:00 PM  and his week ends start from thrusday untill friday.

Two example:

Stage 1 started at 1/1/2012 8:00 AM And ended at 1/1/2012 01:30 PM which means it took the 4 working Hours not 5.5 hours because there was break from 11:30 AM till 1:00 PM

Stage 2 started at 4:00 PM wednsday and ended at 8:30 staraday the working hours spent in this stage is 1 working hours because we are not including the weekend days.

How could we implement this qlikview?

[Gysbert_Wassenaar · Accepted solution]

See here or here.