Hi Community,
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
and
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,
Chris.
User | Count |
---|---|
36 | |
32 | |
30 | |
18 | |
16 |