I have the following command in one of my calculated expressions inside a straight chart
- RangeMax(frac(logdate), MakeTime(8)))
+ (NetWorkDays(logdate, closedate-1) * MakeTime(10)) // Only 10 hours per whole day
The expression ensure that a specific time calucation only occurs on weekdays between 8:00 and 18:00. However I have noticed that if something was logged (logdate) at say: 07:30 and then closed (closedate) at 07:53, it works out the time as -00:07:00.
What it appears to be doing is calculating the time it was closed against the time the clock start ticking, in this instance it is 8:00.
This only occurs when a call is logged and close outside of the calucation (08:00-18:00), is there any way this can be corrected.
Unfortunately I have been assign to different work therefore I have had to put Qlikview on the back burner. However during November I am expecting to go back to this, once I have an answer I will post it on here and ensure you are replied to so it does straight to your e-mail address.