Forum Discussion
Marking a record as day shift or night shift
Hi, I have a data series which shows journeys completed by drivers. Some drivers work a day shift, and others work a night shift. In the data, an individual journey record can be as short as 5 mi...
Vijay_A_Verma
Most Valuable Professional
Most Valuable ProfessionalThanks for the clarity. I have a follow up question before I can come with the intended solution.
How do I determine the start and end of a shift? Is there any identifier or timing or something..
Hence if I have a record for say all 28 days of Feb-22 month, then how will I segregate the shifts?
This is the difficult bit. There should be an 8 hour gap between the end of one shift and the start of the next. There will be expections to this, but this will cover >99% of scenarios. Unfortunately there is no way of determining this with 100% certainty from the data available.