Dear Experts,
We enter some production data - Production qty., Production Start Date & Time, Production Finish Date & Time etc.
Say there are four entries of a single machine -
Order start start time Finish Finish Time 1 01/12/2012 07:00:00 AM 01/12/2012 12:30:00 PM 2 01/12/2012 12:30:00 PM 01/12/2012 05:30:00 PM 3 01/12/2012 01:30:00 PM 01/12/2012 06:00:00 PM 4 01/12/2012 05:30:00 PM 01/12/2012 07:00:00 PM
We can see that the 3'rd entery is wrong, as the machine was busy from 12:30 to 5:30 for order no. 2 & then from 5:30 to 7:00 for order no. 4.
Hence the (entry of ) order 3 can not be processed in-between.
Such errors happens due to wrong data entry as the data entry team has to do hundreds of entries in a day.
Our query is how we can identify such entries. We have tried some logic (attached excel file) but failed to find complete solution.
Please suggest if there is any way out.
Bookmarks