I have one ID for a whole process: #ID 00001 Someone ask for this item
#ID 00001 Someone get the item
#ID 00001 Someone deliver the item
When the same id apear for the third time, it means the whole process has been completed.
When someone ask for the item, this process code change 0 to 1
When someone get the item, this process code change 1 to 2
When someone deliver the item, change 2 - 0
So, i need to know how many items was delivered under 20 minutes, 1 hour, 10 hour and over 10 hours.
If possible to build a sheet that show which item of each time.
Do someone know how can i do this.
Help me understand how this ID would work. There are multiple instances where Prec=5 and Status=2 (and the same with 3/5) so which records are the actual start and end?
