I have this problem and looking for a code that can help me solve it (find values a,b,c in the attached file - sample data).
I've got a team of data enumerators, they record both start and end time of the survey they are collecting data. Now I would like to calculate the time span (minutes or hours) between the end of one survey to the next start of a survey.
Am attaching this dataset for demonstration:
For enumerator Emma, she finished the first survey at 12:01:17 PM and began the next at 12:39:56 PM (approx 40 mins)
Olive on the other hand finished the first interview at 1:05:05 PM and began the next at 2:06:23 PM (an hr later)
How can I calculate difference in these lagged values in a tidyverse context?
A handy way to supply data is to use the dput() function. Do dput(mydata) where "mydata" is the name of your dataset. For really large datasets probably dput(head(mydata, 100)) will do. Paste the output between
```