Forum Discussion
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.
2 Replies
Does the attached workbook do what you want?
- Sorry that did not work, I found Minifs and Maxifs provided the information that is needed, Thank you.
