Discussion Board for collaboration on QlikView Scripting.
a company is open from 07:00 to 13:00 and trucks deliver goods only between these times
So there is a column Total Time spent, which is the total time a truck spent @ the company, even if it was closed.
The column Actual time spent must show the time that the truck spent @ the company between 07:00 and 13:00
Truck one, actual time spent should be 02:00 which is good,
Truck two, actual time spent should be 02:00 (09:00 minus 07:00 (open time))
Truck three, actual time should be 03:00 (10:00 minus 07:00 (open time))
Please see attached
Please Find the attached file . Hope it will helps you
May be attached file might helps
This is helpful, but what happens if the truck arrives at 12:30 PM, and departs at 13:30 PM,
Then the answer will be 13:30 - 07:00 = 6:30, but it should be 30 minutes.
I like the expression, its a little complicated though.
The answer for the last one should be 03:00 though, is that possible?
PFA for solution.
Please see attached under new discussion called time issue 1, I added some more data to the model you sent me, but its still incorrect. I also added a column with the correct answers.