Return given time range in production date code 关注
In our production date codes, we separate each code in 2 hour intervals with each interval represented by a specific text. Here's an example of a lot code:
20L represents a facility
163 represents production Jullian date (in this case June 12)
7 represents year (in this case 2017)
F represents 2 hour time code (in this case 10:00-12:00)
Our time codes could be considered as A=00:00-01:59, B=02:00-03:59, C=04:00-05:59, etc.
The first 3 parts of the code are simple, either embedded text or a date function in a string. My problem starts when attempting to use time ranges in order to lookup my text value. I'm imagining this is solvable using VB script editing, however I'm a complete novice at this.
Does anyone have any recommendations where I can look for additional support or know what kind of script or look ups could be used? Thank you!