I’m building a Diary to determine when someone is working or resting and want to add the time in seconds between entries. There are multiple drivers in the same column
|Date||Driver||Work Rest||Work Rest State|
I’d like to calculate Total Seconds Working and Total Seconds Resting as a starting point.
I figure the easiest way would be to look for the date of the persons previous entry and bring the date into the current row and calculate the time difference between the two dates.
I’m not sure how to bring the previous date into the current row. I hope you can help as this is my first post asking as a question.