Forum Discussion
Production Data - Throughput Target with various shift times
farhandsome Are the shift times well defined as only the examples in your table above? It could possibly be done with lots of IF statements (or a SWITCH??)
Would be easier if you have Date - is there Date columns in both tables that you can combine? Or even if only in the timestamp table, then you can convert the shifts one using dummy dates?
Hi Allison,
Thank you for the response. Unfortunately, the master table above is just an example - there's over 10 sites with multiple shifts each and that could grow, so I'd need a more modular approach rather than using a host of nested if's.
Could you explain how attaching a date would work? For example, a shift of 6pm to 2am would need to have respective dates of [Today] and [Tomorrow], but when the current time passes midnight, those shift dates would need to change to [Yesterday] and [Today]. Does that make sense?