I am trying to develop a way of solving a day shift/ night shift problem (I attach a sample data dump the actual data to be analysed is hundreds of lines). If I have an exited off-site as the first entry of the day this means that the person worked night shift and I need to calculate the hours on site for that day from midnight. If the first entry of the day is a entry to site then I need to calculate the time between this event and the exited off-site event for each employee. If the employee does not exit off-site then I need to calculate the time from the entry to site until midnight.
The sample data is in the format I can extract from my source system. Please assist me in solving this issue.
Cheers
Bookmarks