Time Stamp Location
Greetings
I receive daily report from various machines, and I am attempting to locate the change of shifts time stamps.
Is there a way to locate the first previous time stamp from the start of the shift (the end of the previous shift) and the first-time stamp after the start of shift (workers actually start using the machine)
The file is a sample, and the shift change is 6am (06:00:00″ hh:mm:ss).
Either VBA or function will be greatly appreciated so I can stop manually filtering and looking for Less than .25 or greater than .25.
Greetings I receive daily report from various machines, and I am attempting to locate the change of shifts time stamps. Is there a way to locate the first previous time stamp from the start of the shift (the end of the previous shift) and the first-time stamp after the start of shift (workers actually start using the machine) The file is a sample, and the shift change is 6am (06:00:00″ hh:mm:ss). Either VBA or function will be greatly appreciated so I can stop manually filtering and looking for Less than .25 or greater than .25. Read More