I have some data on Employees clocking in and out from work. I am trying to calculate the duration between clocking in and clocking out. I have not managed to figure out a way to get separate event times on same row to calculate the difference between the events. Or are there some other options to get the desired result?
I have about 50 employee ID:s and a year worth of data. There are several events per employee per day because there are many different events but I'm mainly interested in the time duration between In and Out on daily level.
Any ideas are greatly appriciated, thanks.
Bellow is an example of the kind of data in the table:
Thank you for the reply. I tried out your suggestion and it works for most of the cases. In some cases the clocking in happens during one day and clocking out happens the next day (there are work shifts so some people are working during the night) and in these cases the formula does not return the difference. I'm guessing this is due to selecting the MIN EventTime and MAX EventTime filtered by date?