My app is recording the date/time that a vehicle is loaded.
Our sites run 24/7 meaning that there is a night shift and our shift patterns are:
06:00 - 18:00
18:00 - 06:00
My question is:
How would I be able to count all of the orders loaded within the shift patterns?
I would like to be able to:
Count if an order is loaded between the hours of:
06:00 and 17:59
18:00 and 05:59
I’m able to count if the orders have been loaded between 00:00 and 23:59 but could do with breaking these up.
I have a table “Dates” with a date column [Date] where the table is referencing the table “Order_Flow_Archive” with all of the orders and the timestamp column [Time To Trailer].
I hope I’ve outlined my conundrum in a way that’s easy to understand, but if not please ask.
Any help with this would be mostly appreciated.
Many thanks in advance,