Tagging observations within a varying time window

[Atle Kongsvold]

I have a dataset of the activity participants are doing every hour of up to 7 days. The variables "start_clock" and "end_clock" is when participants are at work. I want to tag the time between "start_clock" and "end_clock" for each participant to be able to extract the activity exclusively in that time period. Participants can have up to three bouts of work each day, so I can't condition on the weekday. I'm able to generate spells, but I haven't found a way to tag the time when I only have the start and the endpoint. I'm hoping to get some help on how to tag the time between start_clock and the next end_clock for every particpant.

 
Participant_id
timestamp
start_clock
end_clock
activity

1
27oct2017 08:00:04
8

1

1
27oct2017 09:00:04
.

1

1
27oct2017 10:00:04
.

1

1
27oct2017 11:00:04
.

2

1
27oct2017 12:00:04
.

1

1
27oct2017 13:00:04
.

2

1
27oct2017 14:00:04
.

2

1
27oct2017 15:00:04
.

2

1
27oct2017 16:00:04
.
16
3

1
27oct2017 17:00:04
.

1

1
27oct2017 18:00:04

1

1
27oct2017 19:00:04

3

1
27oct2017 20:00:04

4

1
27oct2017 21:00:04
21

5

1
27oct2017 22:00:04

4

1
27oct2017 23:00:04
23
2

2
28oct2017 00:00:04

1

2
28oct2017 01:00:04

1

2
28oct2017 02:00:04

2

2
28oct2017 03:00:04

3

2
28oct2017 04:00:04

3

2
28oct2017 05:00:04

3

2
28oct2017 06:00:04

3

2
28oct2017 07:00:04

3

2
28oct2017 08:00:04
8

3

2
28oct2017 09:00:04

4

2
28oct2017 10:00:04

4

2
28oct2017 11:00:04
11
2

[Andrew Musau]

Welcome to Statalist. For your future posts, familiarize yourself with the dataex command for presenting data examples (see FAQ Advice #12 for details). Here, I assume that your time stamp variable is a string.

* Example generated by -dataex-. To install: ssc install dataex
clear
input byte participant_id str18 timestamp byte(start_clock end_clock activity)
1 "27oct2017 08:00:04"  8  . 1
1 "27oct2017 09:00:04"  .  . 1
1 "27oct2017 10:00:04"  .  . 1
1 "27oct2017 11:00:04"  .  . 2
1 "27oct2017 12:00:04"  .  . 1
1 "27oct2017 13:00:04"  .  . 2
1 "27oct2017 14:00:04"  .  . 2
1 "27oct2017 15:00:04"  .  . 2
1 "27oct2017 16:00:04"  . 16 3
1 "27oct2017 17:00:04"  .  . 1
1 "27oct2017 18:00:04"  .  . 1
1 "27oct2017 19:00:04"  .  . 3
1 "27oct2017 20:00:04"  .  . 4
1 "27oct2017 21:00:04" 21  . 5
1 "27oct2017 22:00:04"  .  . 4
1 "27oct2017 23:00:04"  . 23 2
2 "28oct2017 00:00:04"  .  . 1
2 "28oct2017 01:00:04"  .  . 1
2 "28oct2017 02:00:04"  .  . 2
2 "28oct2017 03:00:04"  .  . 3
2 "28oct2017 04:00:04"  .  . 3
2 "28oct2017 05:00:04"  .  . 3
2 "28oct2017 06:00:04"  .  . 3
2 "28oct2017 07:00:04"  .  . 3
2 "28oct2017 08:00:04"  8  . 3
2 "28oct2017 09:00:04"  .  . 4
2 "28oct2017 10:00:04"  .  . 4
2 "28oct2017 11:00:04"  . 11 2
end


gen double time= clock(timestamp, "DMYhms")
format time %tc
gsort participant_id -time
by participant_id: replace end_clock= end_clock[_n-1] if !missing(end_clock[_n-1]) & missing(end_clock)
sort participant_id time
by participant_id: replace start_clock= start_clock[_n-1] if !missing(start_clock[_n-1]) & missing(start_clock) & end_clock== end_clock[_n-1]
replace end_clock= . if missing(start_clock)
gen wanted= !missing(start_clock)

Res.:

. l, sepby(participant_id)

     +----------------------------------------------------------------------------------------------+
     | partic~d            timestamp   start_~k   end_cl~k   activity                 time   wanted |
     |----------------------------------------------------------------------------------------------|
  1. |        1   27oct2017 08:00:04          8         16          1   27oct2017 08:00:04        1 |
  2. |        1   27oct2017 09:00:04          8         16          1   27oct2017 09:00:04        1 |
  3. |        1   27oct2017 10:00:04          8         16          1   27oct2017 10:00:04        1 |
  4. |        1   27oct2017 11:00:04          8         16          2   27oct2017 11:00:04        1 |
  5. |        1   27oct2017 12:00:04          8         16          1   27oct2017 12:00:04        1 |
  6. |        1   27oct2017 13:00:04          8         16          2   27oct2017 13:00:04        1 |
  7. |        1   27oct2017 14:00:04          8         16          2   27oct2017 14:00:04        1 |
  8. |        1   27oct2017 15:00:04          8         16          2   27oct2017 15:00:04        1 |
  9. |        1   27oct2017 16:00:04          8         16          3   27oct2017 16:00:04        1 |
 10. |        1   27oct2017 17:00:04          .          .          1   27oct2017 17:00:04        0 |
 11. |        1   27oct2017 18:00:04          .          .          1   27oct2017 18:00:04        0 |
 12. |        1   27oct2017 19:00:04          .          .          3   27oct2017 19:00:04        0 |
 13. |        1   27oct2017 20:00:04          .          .          4   27oct2017 20:00:04        0 |
 14. |        1   27oct2017 21:00:04         21         23          5   27oct2017 21:00:04        1 |
 15. |        1   27oct2017 22:00:04         21         23          4   27oct2017 22:00:04        1 |
 16. |        1   27oct2017 23:00:04         21         23          2   27oct2017 23:00:04        1 |
     |----------------------------------------------------------------------------------------------|
 17. |        2   28oct2017 00:00:04          .          .          1   28oct2017 00:00:04        0 |
 18. |        2   28oct2017 01:00:04          .          .          1   28oct2017 01:00:04        0 |
 19. |        2   28oct2017 02:00:04          .          .          2   28oct2017 02:00:04        0 |
 20. |        2   28oct2017 03:00:04          .          .          3   28oct2017 03:00:04        0 |
 21. |        2   28oct2017 04:00:04          .          .          3   28oct2017 04:00:04        0 |
 22. |        2   28oct2017 05:00:04          .          .          3   28oct2017 05:00:04        0 |
 23. |        2   28oct2017 06:00:04          .          .          3   28oct2017 06:00:04        0 |
 24. |        2   28oct2017 07:00:04          .          .          3   28oct2017 07:00:04        0 |
 25. |        2   28oct2017 08:00:04          8         11          3   28oct2017 08:00:04        1 |
 26. |        2   28oct2017 09:00:04          8         11          4   28oct2017 09:00:04        1 |
 27. |        2   28oct2017 10:00:04          8         11          4   28oct2017 10:00:04        1 |
 28. |        2   28oct2017 11:00:04          8         11          2   28oct2017 11:00:04        1 |
     +----------------------------------------------------------------------------------------------+

.

[Atle Kongsvold]

Thanks a lot for the answer. The code you provided works to some extent, but there seems to be a hiccup. When I run it, on quite a few of the participants I have, the start_clock and end_clock tagging doesn't stop when it is supposed to, it contiunes to tag "8" and "16" for several days for some participants. See example below
I believe it is happening when I run the following line of code:
by participant_id: replace start_clock= start_clock[_n-1] if !missing(start_clock[_n-1]) & missing(start_clock) & end_clock== end_clock[_n-1]

Do you have a suggestion why this is happening? My dataset looks correct before I run the code, so I dont think there are any missing values that are causing it.

+----------------------------------------------------------------------------------------------+
| partic~d timestamp start_~k end_cl~k activity time wanted |
|----------------------------------------------------------------------------------------------|
1. | 1 27oct2017 08:00:04 8 16 1 27oct2017 08:00:04 1 |
2. | 1 27oct2017 09:00:04 8 16 1 27oct2017 09:00:04 1 |
3. | 1 27oct2017 10:00:04 8 16 1 27oct2017 10:00:04 1 |
4. | 1 27oct2017 11:00:04 8 16 2 27oct2017 11:00:04 1 |
5. | 1 27oct2017 12:00:04 8 16 1 27oct2017 12:00:04 1 |
6. | 1 27oct2017 13:00:04 8 16 2 27oct2017 13:00:04 1 |
7. | 1 27oct2017 14:00:04 8 16 2 27oct2017 14:00:04 1 |
8. | 1 27oct2017 15:00:04 8 16 2 27oct2017 15:00:04 1 |
9. | 1 27oct2017 16:00:04 8 16 3 27oct2017 16:00:04 1 |
10. | 1 27oct2017 17:00:04 8 16 1 27oct2017 17:00:04 1 |
11. | 1 27oct2017 18:00:04 8 16 1 27oct2017 18:00:04 1 |
12. | 1 27oct2017 19:00:04 8 16 3 27oct2017 19:00:04 1 |
13. | 1 27oct2017 20:00:04 8 16 4 27oct2017 20:00:04 1 |
14. | 1 27oct2017 21:00:04 8 16 5 27oct2017 21:00:04 1 |
15. | 1 27oct2017 22:00:04 8 16 4 27oct2017 22:00:04 1 |
16. | 1 27oct2017 23:00:04 8 16 2 27oct2017 23:00:04 1 |
|----------------------------------------------------------------------------------------------|
17. | 2 28oct2017 00:00:04 . . 1 28oct2017 00:00:04 0 |
18. | 2 28oct2017 01:00:04 . . 1 28oct2017 01:00:04 0 |
19. | 2 28oct2017 02:00:04 . . 2 28oct2017 02:00:04 0 |
20. | 2 28oct2017 03:00:04 . . 3 28oct2017 03:00:04 0 |
21. | 2 28oct2017 04:00:04 . . 3 28oct2017 04:00:04 0 |
22. | 2 28oct2017 05:00:04 . . 3 28oct2017 05:00:04 0 |
23. | 2 28oct2017 06:00:04 . . 3 28oct2017 06:00:04 0 |
24. | 2 28oct2017 07:00:04 . . 3 28oct2017 07:00:04 0 |
25. | 2 28oct2017 08:00:04 8 11 3 28oct2017 08:00:04 1 |
26. | 2 28oct2017 09:00:04 8 11 4 28oct2017 09:00:04 1 |
27. | 2 28oct2017 10:00:04 8 11 4 28oct2017 10:00:04 1 |
28. | 2 28oct2017 11:00:04 8 11 2 28oct2017 11:00:04 1 |
+----------------------------------------------------------------------------------------------+

.

[Andrew Musau]

Read the comment in #2 on dataex and then represent your data example.

[Atle Kongsvold]

The following syntax:
gen double time= clock(timestamp, "YMDhms")
format time %tc
gsort participant_id -time
by participant_id: replace end_clock= end_clock[_n-1] if !missing(end_clock[_n-1]) & missing(end_clock)
sort participant_id time
by participant_id: replace start_clock= start_clock[_n-1] if !missing(start_clock[_n-1]) & missing(start_clock) & end_clock== end_clock[_n-1]
replace end_clock= . if missing(start_clock)
gen wanted= !missing(start_clock)
Produces this output:

* Example generated by -dataex-. To install: ssc install dataex
clear
input double participant_id str23 timestamp int  activity float(start_clock end_clock) double time float wanted
1111110001234 "2018-03-14 08:00:04.980"   6 8 13 1836633604980 1
1111110001234 "2018-03-14 09:00:04.980"   7 8 13 1836637204980 1
1111110001234 "2018-03-14 10:00:04.980"   6 8 13 1836640804980 1
1111110001234 "2018-03-14 11:00:04.980"   6 8 13 1836644404980 1
1111110001234 "2018-03-14 12:00:04.980"   7 8 13 1836648004980 1
1111110001234 "2018-03-14 13:00:04.980"   6 8 13 1836651604980 1
1111110001234 "2018-03-14 14:00:04.980"   7 8 13 1836655204980 1
1111110001234 "2018-03-14 15:00:04.980"   7 8 13 1836658804980 1
1111110001234 "2018-03-14 16:00:04.980"   6 8 13 1836662404980 1
1111110001234 "2018-03-14 17:00:04.980"   7 8 13 1836666004980 1
1111110001234 "2018-03-14 18:00:04.980"   6 8 13 1836669604980 1
1111110001234 "2018-03-14 19:00:04.980"   7 8 13 1836673204980 1
1111110001234 "2018-03-14 20:00:04.980"   7 8 13 1836676804980 1
1111110001234 "2018-03-14 21:00:04.980"   7 8 13 1836680404980 1
1111110001234 "2018-03-14 22:00:04.980"   7 8 13 1836684004980 1
1111110001234 "2018-03-14 23:00:04.980"   8 8 13 1836687604980 1
1111110001234 "2018-03-15 00:00:04.980"   8 8 13 1836691204980 1
1111110001234 "2018-03-15 01:00:04.980"   8 8 13 1836694804980 1
1111110001234 "2018-03-15 02:00:04.980"   8 8 13 1836698404980 1
1111110001234 "2018-03-15 03:00:04.980"   8 8 13 1836702004980 1
1111110001234 "2018-03-15 04:00:04.980"   8 8 13 1836705604980 1
1111110001234 "2018-03-15 05:00:04.980"   8 8 13 1836709204980 1
1111110001234 "2018-03-15 06:00:04.980"   6 8 13 1836712804980 1
1111110001234 "2018-03-15 07:00:04.980"   6 8 13 1836716404980 1
1111110001234 "2018-03-15 08:00:04.980"   6 8 13 1836720004980 1
end
format %tc time

As you can see, the output is not what I wanted. The taggng of each hour doesnt stop after 13, just continues for several days. Any suggestions to what could be the issue?

[Andrew Musau]

I do not see how you end up with the dataset in #5. You should present the dataset before running the suggested code. The code in #2 is structured to the data presented in #1. In any case, you can address the issue retrospectively.

* Example generated by -dataex-. To install: ssc install dataex
clear
input double participant_id str23 timestamp int  activity float(start_clock end_clock) double time float wanted
1111110001234 "2018-03-14 08:00:04.980"   6 8 13 1836633604980 1
1111110001234 "2018-03-14 09:00:04.980"   7 8 13 1836637204980 1
1111110001234 "2018-03-14 10:00:04.980"   6 8 13 1836640804980 1
1111110001234 "2018-03-14 11:00:04.980"   6 8 13 1836644404980 1
1111110001234 "2018-03-14 12:00:04.980"   7 8 13 1836648004980 1
1111110001234 "2018-03-14 13:00:04.980"   6 8 13 1836651604980 1
1111110001234 "2018-03-14 14:00:04.980"   7 8 13 1836655204980 1
1111110001234 "2018-03-14 15:00:04.980"   7 8 13 1836658804980 1
1111110001234 "2018-03-14 16:00:04.980"   6 8 13 1836662404980 1
1111110001234 "2018-03-14 17:00:04.980"   7 8 13 1836666004980 1
1111110001234 "2018-03-14 18:00:04.980"   6 8 13 1836669604980 1
1111110001234 "2018-03-14 19:00:04.980"   7 8 13 1836673204980 1
1111110001234 "2018-03-14 20:00:04.980"   7 8 13 1836676804980 1
1111110001234 "2018-03-14 21:00:04.980"   7 8 13 1836680404980 1
1111110001234 "2018-03-14 22:00:04.980"   7 8 13 1836684004980 1
1111110001234 "2018-03-14 23:00:04.980"   8 8 13 1836687604980 1
1111110001234 "2018-03-15 00:00:04.980"   8 8 13 1836691204980 1
1111110001234 "2018-03-15 01:00:04.980"   8 8 13 1836694804980 1
1111110001234 "2018-03-15 02:00:04.980"   8 8 13 1836698404980 1
1111110001234 "2018-03-15 03:00:04.980"   8 8 13 1836702004980 1
1111110001234 "2018-03-15 04:00:04.980"   8 8 13 1836705604980 1
1111110001234 "2018-03-15 05:00:04.980"   8 8 13 1836709204980 1
1111110001234 "2018-03-15 06:00:04.980"   6 8 13 1836712804980 1
1111110001234 "2018-03-15 07:00:04.980"   6 8 13 1836716404980 1
1111110001234 "2018-03-15 08:00:04.980"   6 8 13 1836720004980 1
end
format %tc time

gen hr= real(ustrregexra(timestamp, ".*\s(\d{2}):.*", "$1"))
replace wanted=!wanted if !inrange(hr, start_clock, end_clock)

Res.:

. l, sep(0)

     +-------------------------------------------------------------------------------------------------------------+
     | participant~d                 timestamp   activity   start_~k   end_cl~k                 time   wanted   hr |
     |-------------------------------------------------------------------------------------------------------------|
  1. | 1111110001234   2018-03-14 08:00:04.980          6          8         13   14mar2018 08:00:04        1    8 |
  2. | 1111110001234   2018-03-14 09:00:04.980          7          8         13   14mar2018 09:00:04        1    9 |
  3. | 1111110001234   2018-03-14 10:00:04.980          6          8         13   14mar2018 10:00:04        1   10 |
  4. | 1111110001234   2018-03-14 11:00:04.980          6          8         13   14mar2018 11:00:04        1   11 |
  5. | 1111110001234   2018-03-14 12:00:04.980          7          8         13   14mar2018 12:00:04        1   12 |
  6. | 1111110001234   2018-03-14 13:00:04.980          6          8         13   14mar2018 13:00:04        1   13 |
  7. | 1111110001234   2018-03-14 14:00:04.980          7          8         13   14mar2018 14:00:04        0   14 |
  8. | 1111110001234   2018-03-14 15:00:04.980          7          8         13   14mar2018 15:00:04        0   15 |
  9. | 1111110001234   2018-03-14 16:00:04.980          6          8         13   14mar2018 16:00:04        0   16 |
 10. | 1111110001234   2018-03-14 17:00:04.980          7          8         13   14mar2018 17:00:04        0   17 |
 11. | 1111110001234   2018-03-14 18:00:04.980          6          8         13   14mar2018 18:00:04        0   18 |
 12. | 1111110001234   2018-03-14 19:00:04.980          7          8         13   14mar2018 19:00:04        0   19 |
 13. | 1111110001234   2018-03-14 20:00:04.980          7          8         13   14mar2018 20:00:04        0   20 |
 14. | 1111110001234   2018-03-14 21:00:04.980          7          8         13   14mar2018 21:00:04        0   21 |
 15. | 1111110001234   2018-03-14 22:00:04.980          7          8         13   14mar2018 22:00:04        0   22 |
 16. | 1111110001234   2018-03-14 23:00:04.980          8          8         13   14mar2018 23:00:04        0   23 |
 17. | 1111110001234   2018-03-15 00:00:04.980          8          8         13   15mar2018 00:00:04        0    0 |
 18. | 1111110001234   2018-03-15 01:00:04.980          8          8         13   15mar2018 01:00:04        0    1 |
 19. | 1111110001234   2018-03-15 02:00:04.980          8          8         13   15mar2018 02:00:04        0    2 |
 20. | 1111110001234   2018-03-15 03:00:04.980          8          8         13   15mar2018 03:00:04        0    3 |
 21. | 1111110001234   2018-03-15 04:00:04.980          8          8         13   15mar2018 04:00:04        0    4 |
 22. | 1111110001234   2018-03-15 05:00:04.980          8          8         13   15mar2018 05:00:04        0    5 |
 23. | 1111110001234   2018-03-15 06:00:04.980          6          8         13   15mar2018 06:00:04        0    6 |
 24. | 1111110001234   2018-03-15 07:00:04.980          6          8         13   15mar2018 07:00:04        0    7 |
 25. | 1111110001234   2018-03-15 08:00:04.980          6          8         13   15mar2018 08:00:04        1    8 |
     +-------------------------------------------------------------------------------------------------------------+

.

[Atle Kongsvold]

Thank you for the response. The retrospective fix does not work, as this person worked from 8 to 13 the first day (14.03.2018), but did not work at all the next day (15.03.2018). But the fix tags hr "8" the next day as well as it fullfills the requirement. "8" and "13" is tagged for all observations until there is a change in the working time. I'm now trying to provide of my original dataset before running any code. It is actually activity minute by minute for every person from one to six days of measurement for all participant. Maybe the first batch of code has to be structured a bit different to be applicable.

* Example generated by -dataex-. To install: ssc install dataex
clear
input double participant_id str23 timestamp int activity float(start_clock end_clock)
1111110000111 "2017-12-04 07:00:04.980" 7 7  .
1111110000111 "2017-12-04 07:01:04.980" 7 .  .
1111110000111 "2017-12-04 07:02:04.980" 1 .  .
1111110000111 "2017-12-04 07:03:04.980" 6 .  .
1111110000111 "2017-12-04 07:04:04.980" 1 .  .
1111110000111 "2017-12-04 07:05:04.980" 1 .  .
1111110000111 "2017-12-04 07:06:04.980" 1 .  .
1111110000111 "2017-12-04 07:07:04.980" 6 .  .
1111110000111 "2017-12-04 07:08:04.980" 6 .  .
1111110000111 "2017-12-04 07:09:04.980" 6 .  .
1111110000111 "2017-12-04 07:10:04.980" 6 .  .
1111110000111 "2017-12-04 07:11:04.980" 6 .  .
1111110000111 "2017-12-04 07:12:04.980" 1 .  .
1111110000111 "2017-12-04 07:13:04.980" 6 .  .
1111110000111 "2017-12-04 07:14:04.980" 6 .  .
1111110000111 "2017-12-04 07:15:04.980" 6 .  .
1111110000111 "2017-12-04 07:16:04.980" 6 .  .
1111110000111 "2017-12-04 07:17:04.980" 6 .  .
1111110000111 "2017-12-04 07:18:04.980" 6 .  .
1111110000111 "2017-12-04 07:19:04.980" 6 .  .
1111110000111 "2017-12-04 07:20:04.980" 6 .  .
1111110000111 "2017-12-04 07:21:04.980" 6 .  .
1111110000111 "2017-12-04 07:22:04.980" 1 .  .
1111110000111 "2017-12-04 07:23:04.980" 3 .  .
1111110000111 "2017-12-04 07:24:04.980" 6 .  .
1111110000111 "2017-12-04 07:25:04.980" 3 .  .
1111110000111 "2017-12-04 07:26:04.980" 6 .  .
1111110000111 "2017-12-04 07:27:04.980" 6 .  .
1111110000111 "2017-12-04 07:28:04.980" 1 .  .
1111110000111 "2017-12-04 07:29:04.980" 6 .  .
1111110000111 "2017-12-04 07:30:04.980" 6 .  .
1111110000111 "2017-12-04 07:31:04.980" 6 .  .
1111110000111 "2017-12-04 07:32:04.980" 6 .  .
1111110000111 "2017-12-04 07:33:04.980" 6 .  .
1111110000111 "2017-12-04 07:34:04.980" 6 .  .
1111110000111 "2017-12-04 07:35:04.980" 7 .  .
1111110000111 "2017-12-04 07:36:04.980" 7 .  .
1111110000111 "2017-12-04 07:37:04.980" 6 .  .
1111110000111 "2017-12-04 07:38:04.980" 6 .  .
1111110000111 "2017-12-04 07:39:04.980" 6 .  .
1111110000111 "2017-12-04 07:40:04.980" 6 .  .
1111110000111 "2017-12-04 07:41:04.980" 6 .  .
1111110000111 "2017-12-04 07:42:04.980" 6 .  .
1111110000111 "2017-12-04 07:43:04.980" 6 .  .
1111110000111 "2017-12-04 07:44:04.980" 6 .  .
1111110000111 "2017-12-04 07:45:04.980" 6 .  .
1111110000111 "2017-12-04 07:46:04.980" 6 .  .
1111110000111 "2017-12-04 07:47:04.980" 6 .  .
1111110000111 "2017-12-04 07:48:04.980" 6 .  .
1111110000111 "2017-12-04 07:49:04.980" 6 .  .
1111110000111 "2017-12-04 07:50:04.980" 6 .  .
1111110000111 "2017-12-04 07:51:04.980" 6 .  .
1111110000111 "2017-12-04 07:52:04.980" 6 .  .
1111110000111 "2017-12-04 07:53:04.980" 1 .  .
1111110000111 "2017-12-04 07:54:04.980" 1 .  .
1111110000111 "2017-12-04 07:55:04.980" 6 .  .
1111110000111 "2017-12-04 07:56:04.980" 6 .  .
1111110000111 "2017-12-04 07:57:04.980" 6 .  .
1111110000111 "2017-12-04 07:58:04.980" 6 .  .
1111110000111 "2017-12-04 07:59:04.980" 6 .  .
1111110000111 "2017-12-04 08:00:04.980" 1 .  .
1111110000111 "2017-12-04 08:01:04.980" 1 .  .
1111110000111 "2017-12-04 08:02:04.980" 6 .  .
1111110000111 "2017-12-04 08:03:04.980" 6 .  .
1111110000111 "2017-12-04 08:04:04.980" 6 .  .
1111110000111 "2017-12-04 08:05:04.980" 1 .  .
1111110000111 "2017-12-04 08:06:04.980" 1 .  .
1111110000111 "2017-12-04 08:07:04.980" 6 .  .
1111110000111 "2017-12-04 08:08:04.980" 6 .  .
1111110000111 "2017-12-04 08:09:04.980" 6 .  .
1111110000111 "2017-12-04 08:10:04.980" 6 .  .
1111110000111 "2017-12-04 08:11:04.980" 6 .  .
1111110000111 "2017-12-04 08:12:04.980" 6 .  .
1111110000111 "2017-12-04 08:13:04.980" 6 .  .
1111110000111 "2017-12-04 08:14:04.980" 1 .  .
1111110000111 "2017-12-04 08:15:04.980" 6 .  .
1111110000111 "2017-12-04 08:16:04.980" 6 .  .
1111110000111 "2017-12-04 08:17:04.980" 6 .  .
1111110000111 "2017-12-04 08:18:04.980" 6 .  .
1111110000111 "2017-12-04 08:19:04.980" 6 .  .
1111110000111 "2017-12-04 08:20:04.980" 6 .  .
1111110000111 "2017-12-04 08:21:04.980" 7 .  .
1111110000111 "2017-12-04 08:22:04.980" 6 .  .
1111110000111 "2017-12-04 08:23:04.980" 6 .  .
1111110000111 "2017-12-04 08:24:04.980" 6 .  .
1111110000111 "2017-12-04 08:25:04.980" 6 .  .
1111110000111 "2017-12-04 08:26:04.980" 6 .  .
1111110000111 "2017-12-04 08:27:04.980" 1 .  .
1111110000111 "2017-12-04 08:28:04.980" 6 .  .
1111110000111 "2017-12-04 08:29:04.980" 6 .  .
1111110000111 "2017-12-04 08:30:04.980" 1 .  .
1111110000111 "2017-12-04 08:31:04.980" 1 .  .
1111110000111 "2017-12-04 08:32:04.980" 6 .  .
1111110000111 "2017-12-04 08:33:04.980" 6 .  .
1111110000111 "2017-12-04 08:34:04.980" 1 .  .
1111110000111 "2017-12-04 08:35:04.980" 6 .  .
1111110000111 "2017-12-04 08:36:04.980" 1 .  .
1111110000111 "2017-12-04 08:37:04.980" 3 .  .
1111110000111 "2017-12-04 08:38:04.980" 1 .  .
1111110000111 "2017-12-04 08:39:04.980" 3 .  .
1111110000111 "2017-12-04 08:40:04.980" 3 .  .
1111110000111 "2017-12-04 08:41:04.980" 6 .  .
1111110000111 "2017-12-04 08:42:04.980" 6 .  .
1111110000111 "2017-12-04 08:43:04.980" 6 .  .
1111110000111 "2017-12-04 08:44:04.980" 6 .  .
1111110000111 "2017-12-04 08:45:04.980" 3 .  .
1111110000111 "2017-12-04 08:46:04.980" 3 .  .
1111110000111 "2017-12-04 08:47:04.980" 1 .  .
1111110000111 "2017-12-04 08:48:04.980" 6 .  .
1111110000111 "2017-12-04 08:49:04.980" 6 .  .
1111110000111 "2017-12-04 08:50:04.980" 6 .  .
1111110000111 "2017-12-04 08:51:04.980" 6 .  .
1111110000111 "2017-12-04 08:52:04.980" 6 .  .
1111110000111 "2017-12-04 08:53:04.980" 6 .  .
1111110000111 "2017-12-04 08:54:04.980" 6 .  .
1111110000111 "2017-12-04 08:55:04.980" 6 .  .
1111110000111 "2017-12-04 08:56:04.980" 1 .  .
1111110000111 "2017-12-04 08:57:04.980" 6 .  .
1111110000111 "2017-12-04 08:58:04.980" 1 .  .
1111110000111 "2017-12-04 08:59:04.980" 6 .  .
1111110000111 "2017-12-04 09:00:04.980" 6 .  .
1111110000111 "2017-12-04 09:01:04.980" 6 .  .
1111110000111 "2017-12-04 09:02:04.980" 6 .  .
1111110000111 "2017-12-04 09:03:04.980" 6 .  .
1111110000111 "2017-12-04 09:04:04.980" 6 .  .
1111110000111 "2017-12-04 09:05:04.980" 1 .  .
1111110000111 "2017-12-04 09:06:04.980" 7 .  .
1111110000111 "2017-12-04 09:07:04.980" 6 .  .
1111110000111 "2017-12-04 09:08:04.980" 6 .  .
1111110000111 "2017-12-04 09:09:04.980" 6 .  .
1111110000111 "2017-12-04 09:10:04.980" 6 .  .
1111110000111 "2017-12-04 09:11:04.980" 6 .  .
1111110000111 "2017-12-04 09:12:04.980" 6 .  .
1111110000111 "2017-12-04 09:13:04.980" 6 .  .
1111110000111 "2017-12-04 09:14:04.980" 1 .  .
1111110000111 "2017-12-04 09:15:04.980" 6 .  .
1111110000111 "2017-12-04 09:16:04.980" 6 .  .
1111110000111 "2017-12-04 09:17:04.980" 6 .  .
1111110000111 "2017-12-04 09:18:04.980" 6 .  .
1111110000111 "2017-12-04 09:19:04.980" 6 .  .
1111110000111 "2017-12-04 09:20:04.980" 6 .  .
1111110000111 "2017-12-04 09:21:04.980" 6 .  .
1111110000111 "2017-12-04 09:22:04.980" 6 .  .
1111110000111 "2017-12-04 09:23:04.980" 6 .  .
1111110000111 "2017-12-04 09:24:04.980" 6 .  .
1111110000111 "2017-12-04 09:25:04.980" 6 .  .
1111110000111 "2017-12-04 09:26:04.980" 6 .  .
1111110000111 "2017-12-04 09:27:04.980" 6 .  .
1111110000111 "2017-12-04 09:28:04.980" 6 .  .
1111110000111 "2017-12-04 09:29:04.980" 6 .  .
1111110000111 "2017-12-04 09:30:04.980" 1 .  .
1111110000111 "2017-12-04 09:31:04.980" 1 .  .
1111110000111 "2017-12-04 09:32:04.980" 1 .  .
1111110000111 "2017-12-04 09:33:04.980" 6 .  .
1111110000111 "2017-12-04 09:34:04.980" 7 .  .
1111110000111 "2017-12-04 09:35:04.980" 7 .  .
1111110000111 "2017-12-04 09:36:04.980" 7 .  .
1111110000111 "2017-12-04 09:37:04.980" 7 .  .
1111110000111 "2017-12-04 09:38:04.980" 7 .  .
1111110000111 "2017-12-04 09:39:04.980" 6 .  .
1111110000111 "2017-12-04 09:40:04.980" 7 .  .
1111110000111 "2017-12-04 09:41:04.980" 7 .  .
1111110000111 "2017-12-04 09:42:04.980" 7 .  .
1111110000111 "2017-12-04 09:43:04.980" 7 .  .
1111110000111 "2017-12-04 09:44:04.980" 7 .  .
1111110000111 "2017-12-04 09:45:04.980" 7 .  .
1111110000111 "2017-12-04 09:46:04.980" 7 .  .
1111110000111 "2017-12-04 09:47:04.980" 7 .  .
1111110000111 "2017-12-04 09:48:04.980" 7 .  .
1111110000111 "2017-12-04 09:49:04.980" 7 .  .
1111110000111 "2017-12-04 09:50:04.980" 7 .  .
1111110000111 "2017-12-04 09:51:04.980" 7 .  .
1111110000111 "2017-12-04 09:52:04.980" 7 .  .
1111110000111 "2017-12-04 09:53:04.980" 7 .  .
1111110000111 "2017-12-04 09:54:04.980" 7 .  .
1111110000111 "2017-12-04 09:55:04.980" 7 .  .
1111110000111 "2017-12-04 09:56:04.980" 7 .  .
1111110000111 "2017-12-04 09:57:04.980" 7 .  .
1111110000111 "2017-12-04 09:58:04.980" 7 .  .
1111110000111 "2017-12-04 09:59:04.980" 1 .  .
1111110000111 "2017-12-04 10:00:04.980" 1 .  .
1111110000111 "2017-12-04 10:01:04.980" 1 .  .
1111110000111 "2017-12-04 10:02:04.980" 6 .  .
1111110000111 "2017-12-04 10:03:04.980" 6 .  .
1111110000111 "2017-12-04 10:04:04.980" 6 .  .
1111110000111 "2017-12-04 10:05:04.980" 6 .  .
1111110000111 "2017-12-04 10:06:04.980" 6 .  .
1111110000111 "2017-12-04 10:07:04.980" 6 .  .
1111110000111 "2017-12-04 10:08:04.980" 1 .  .
1111110000111 "2017-12-04 10:09:04.980" 3 .  .
1111110000111 "2017-12-04 10:10:04.980" 7 .  .
1111110000111 "2017-12-04 10:11:04.980" 3 .  .
1111110000111 "2017-12-04 10:12:04.980" 6 .  .
1111110000111 "2017-12-04 10:13:04.980" 3 .  .
1111110000111 "2017-12-04 10:14:04.980" 6 .  .
1111110000111 "2017-12-04 10:15:04.980" 6 .  .
1111110000111 "2017-12-04 10:16:04.980" 6 .  .
1111110000111 "2017-12-04 10:17:04.980" 6 .  .
1111110000111 "2017-12-04 10:18:04.980" 6 .  .
1111110000111 "2017-12-04 10:19:04.980" 6 .  .
1111110000111 "2017-12-04 10:20:04.980" 6 .  .
1111110000111 "2017-12-04 10:21:04.980" 1 .  .
1111110000111 "2017-12-04 10:22:04.980" 1 .  .
1111110000111 "2017-12-04 10:23:04.980" 6 .  .
1111110000111 "2017-12-04 10:24:04.980" 6 .  .
1111110000111 "2017-12-04 10:25:04.980" 6 .  .
1111110000111 "2017-12-04 10:26:04.980" 6 .  .
1111110000111 "2017-12-04 10:27:04.980" 6 .  .
1111110000111 "2017-12-04 10:28:04.980" 6 .  .
1111110000111 "2017-12-04 10:29:04.980" 6 .  .
1111110000111 "2017-12-04 10:30:04.980" 6 .  .
1111110000111 "2017-12-04 10:31:04.980" 6 .  .
1111110000111 "2017-12-04 10:32:04.980" 6 .  .
1111110000111 "2017-12-04 10:33:04.980" 6 .  .
1111110000111 "2017-12-04 10:34:04.980" 1 .  .
1111110000111 "2017-12-04 10:35:04.980" 1 .  .
1111110000111 "2017-12-04 10:36:04.980" 6 .  .
1111110000111 "2017-12-04 10:37:04.980" 6 .  .
1111110000111 "2017-12-04 10:38:04.980" 6 .  .
1111110000111 "2017-12-04 10:39:04.980" 6 .  .
1111110000111 "2017-12-04 10:40:04.980" 6 .  .
1111110000111 "2017-12-04 10:41:04.980" 3 .  .
1111110000111 "2017-12-04 10:42:04.980" 6 .  .
1111110000111 "2017-12-04 10:43:04.980" 6 .  .
1111110000111 "2017-12-04 10:44:04.980" 6 .  .
1111110000111 "2017-12-04 10:45:04.980" 1 .  .
1111110000111 "2017-12-04 10:46:04.980" 6 .  .
1111110000111 "2017-12-04 10:47:04.980" 6 .  .
1111110000111 "2017-12-04 10:48:04.980" 6 .  .
1111110000111 "2017-12-04 10:49:04.980" 6 .  .
1111110000111 "2017-12-04 10:50:04.980" 6 .  .
1111110000111 "2017-12-04 10:51:04.980" 6 .  .
1111110000111 "2017-12-04 10:52:04.980" 6 .  .
1111110000111 "2017-12-04 10:53:04.980" 6 .  .
1111110000111 "2017-12-04 10:54:04.980" 6 .  .
1111110000111 "2017-12-04 10:55:04.980" 6 .  .
1111110000111 "2017-12-04 10:56:04.980" 6 .  .
1111110000111 "2017-12-04 10:57:04.980" 6 .  .
1111110000111 "2017-12-04 10:58:04.980" 6 .  .
1111110000111 "2017-12-04 10:59:04.980" 1 .  .
1111110000111 "2017-12-04 11:00:04.980" 6 .  .
1111110000111 "2017-12-04 11:01:04.980" 6 .  .
1111110000111 "2017-12-04 11:02:04.980" 6 .  .
1111110000111 "2017-12-04 11:03:04.980" 6 .  .
1111110000111 "2017-12-04 11:04:04.980" 6 .  .
1111110000111 "2017-12-04 11:05:04.980" 6 .  .
1111110000111 "2017-12-04 11:06:04.980" 6 .  .
1111110000111 "2017-12-04 11:07:04.980" 6 .  .
1111110000111 "2017-12-04 11:08:04.980" 6 .  .
1111110000111 "2017-12-04 11:09:04.980" 6 .  .
1111110000111 "2017-12-04 11:10:04.980" 6 .  .
1111110000111 "2017-12-04 11:11:04.980" 6 .  .
1111110000111 "2017-12-04 11:12:04.980" 6 .  .
1111110000111 "2017-12-04 11:13:04.980" 6 .  .
1111110000111 "2017-12-04 11:14:04.980" 6 .  .
1111110000111 "2017-12-04 11:15:04.980" 6 .  .
1111110000111 "2017-12-04 11:16:04.980" 6 .  .
1111110000111 "2017-12-04 11:17:04.980" 6 .  .
1111110000111 "2017-12-04 11:18:04.980" 6 .  .
1111110000111 "2017-12-04 11:19:04.980" 6 .  .
1111110000111 "2017-12-04 11:20:04.980" 6 .  .
1111110000111 "2017-12-04 11:21:04.980" 6 .  .
1111110000111 "2017-12-04 11:22:04.980" 6 .  .
1111110000111 "2017-12-04 11:23:04.980" 6 .  .
1111110000111 "2017-12-04 11:24:04.980" 6 .  .
1111110000111 "2017-12-04 11:25:04.980" 6 .  .
1111110000111 "2017-12-04 11:26:04.980" 1 .  .
1111110000111 "2017-12-04 11:27:04.980" 6 .  .
1111110000111 "2017-12-04 11:28:04.980" 6 .  .
1111110000111 "2017-12-04 11:29:04.980" 3 .  .
1111110000111 "2017-12-04 11:30:04.980" 1 .  .
1111110000111 "2017-12-04 11:31:04.980" 6 .  .
1111110000111 "2017-12-04 11:32:04.980" 6 .  .
1111110000111 "2017-12-04 11:33:04.980" 6 .  .
1111110000111 "2017-12-04 11:34:04.980" 6 .  .
1111110000111 "2017-12-04 11:35:04.980" 6 .  .
1111110000111 "2017-12-04 11:36:04.980" 6 .  .
1111110000111 "2017-12-04 11:37:04.980" 6 .  .
1111110000111 "2017-12-04 11:38:04.980" 1 .  .
1111110000111 "2017-12-04 11:39:04.980" 6 .  .
1111110000111 "2017-12-04 11:40:04.980" 6 .  .
1111110000111 "2017-12-04 11:41:04.980" 6 .  .
1111110000111 "2017-12-04 11:42:04.980" 6 .  .
1111110000111 "2017-12-04 11:43:04.980" 6 .  .
1111110000111 "2017-12-04 11:44:04.980" 7 .  .
1111110000111 "2017-12-04 11:45:04.980" 6 .  .
1111110000111 "2017-12-04 11:46:04.980" 6 .  .
1111110000111 "2017-12-04 11:47:04.980" 1 .  .
1111110000111 "2017-12-04 11:48:04.980" 6 .  .
1111110000111 "2017-12-04 11:49:04.980" 6 .  .
1111110000111 "2017-12-04 11:50:04.980" 6 .  .
1111110000111 "2017-12-04 11:51:04.980" 6 .  .
1111110000111 "2017-12-04 11:52:04.980" 6 .  .
1111110000111 "2017-12-04 11:53:04.980" 6 .  .
1111110000111 "2017-12-04 11:54:04.980" 6 .  .
1111110000111 "2017-12-04 11:55:04.980" 6 .  .
1111110000111 "2017-12-04 11:56:04.980" 6 .  .
1111110000111 "2017-12-04 11:57:04.980" 6 .  .
1111110000111 "2017-12-04 11:58:04.980" 6 .  .
1111110000111 "2017-12-04 11:59:04.980" 1 .  .
1111110000111 "2017-12-04 12:00:04.980" 1 .  .
1111110000111 "2017-12-04 12:01:04.980" 1 .  .
1111110000111 "2017-12-04 12:02:04.980" 1 .  .
1111110000111 "2017-12-04 12:03:04.980" 1 .  .
1111110000111 "2017-12-04 12:04:04.980" 6 .  .
1111110000111 "2017-12-04 12:05:04.980" 7 .  .
1111110000111 "2017-12-04 12:06:04.980" 7 .  .
1111110000111 "2017-12-04 12:07:04.980" 7 .  .
1111110000111 "2017-12-04 12:08:04.980" 7 .  .
1111110000111 "2017-12-04 12:09:04.980" 7 .  .
1111110000111 "2017-12-04 12:10:04.980" 7 .  .
1111110000111 "2017-12-04 12:11:04.980" 7 .  .
1111110000111 "2017-12-04 12:12:04.980" 7 .  .
1111110000111 "2017-12-04 12:13:04.980" 7 .  .
1111110000111 "2017-12-04 12:14:04.980" 7 .  .
1111110000111 "2017-12-04 12:15:04.980" 7 .  .
1111110000111 "2017-12-04 12:16:04.980" 7 .  .
1111110000111 "2017-12-04 12:17:04.980" 7 .  .
1111110000111 "2017-12-04 12:18:04.980" 7 .  .
1111110000111 "2017-12-04 12:19:04.980" 7 .  .
1111110000111 "2017-12-04 12:20:04.980" 7 .  .
1111110000111 "2017-12-04 12:21:04.980" 7 .  .
1111110000111 "2017-12-04 12:22:04.980" 7 .  .
1111110000111 "2017-12-04 12:23:04.980" 7 .  .
1111110000111 "2017-12-04 12:24:04.980" 7 .  .
1111110000111 "2017-12-04 12:25:04.980" 7 .  .
1111110000111 "2017-12-04 12:26:04.980" 7 .  .
1111110000111 "2017-12-04 12:27:04.980" 7 .  .
1111110000111 "2017-12-04 12:28:04.980" 7 .  .
1111110000111 "2017-12-04 12:29:04.980" 7 .  .
1111110000111 "2017-12-04 12:30:04.980" 7 .  .
1111110000111 "2017-12-04 12:31:04.980" 7 .  .
1111110000111 "2017-12-04 12:32:04.980" 7 .  .
1111110000111 "2017-12-04 12:33:04.980" 1 .  .
1111110000111 "2017-12-04 12:34:04.980" 1 .  .
1111110000111 "2017-12-04 12:35:04.980" 1 .  .
1111110000111 "2017-12-04 12:36:04.980" 1 .  .
1111110000111 "2017-12-04 12:37:04.980" 6 .  .
1111110000111 "2017-12-04 12:38:04.980" 6 .  .
1111110000111 "2017-12-04 12:39:04.980" 1 .  .
1111110000111 "2017-12-04 12:40:04.980" 6 .  .
1111110000111 "2017-12-04 12:41:04.980" 6 .  .
1111110000111 "2017-12-04 12:42:04.980" 6 .  .
1111110000111 "2017-12-04 12:43:04.980" 6 .  .
1111110000111 "2017-12-04 12:44:04.980" 6 .  .
1111110000111 "2017-12-04 12:45:04.980" 6 .  .
1111110000111 "2017-12-04 12:46:04.980" 6 .  .
1111110000111 "2017-12-04 12:47:04.980" 6 .  .
1111110000111 "2017-12-04 12:48:04.980" 6 .  .
1111110000111 "2017-12-04 12:49:04.980" 6 .  .
1111110000111 "2017-12-04 12:50:04.980" 6 .  .
1111110000111 "2017-12-04 12:51:04.980" 6 .  .
1111110000111 "2017-12-04 12:52:04.980" 6 .  .
1111110000111 "2017-12-04 12:53:04.980" 1 .  .
1111110000111 "2017-12-04 12:54:04.980" 1 .  .
1111110000111 "2017-12-04 12:55:04.980" 6 .  .
1111110000111 "2017-12-04 12:56:04.980" 6 .  .
1111110000111 "2017-12-04 12:57:04.980" 6 .  .
1111110000111 "2017-12-04 12:58:04.980" 6 .  .
1111110000111 "2017-12-04 12:59:04.980" 6 .  .
1111110000111 "2017-12-04 13:00:04.980" 6 .  .
1111110000111 "2017-12-04 13:01:04.980" 6 .  .
1111110000111 "2017-12-04 13:02:04.980" 6 .  .
1111110000111 "2017-12-04 13:03:04.980" 6 .  .
1111110000111 "2017-12-04 13:04:04.980" 6 .  .
1111110000111 "2017-12-04 13:05:04.980" 6 .  .
1111110000111 "2017-12-04 13:06:04.980" 6 .  .
1111110000111 "2017-12-04 13:07:04.980" 6 .  .
1111110000111 "2017-12-04 13:08:04.980" 6 .  .
1111110000111 "2017-12-04 13:09:04.980" 6 .  .
1111110000111 "2017-12-04 13:10:04.980" 6 .  .
1111110000111 "2017-12-04 13:11:04.980" 6 .  .
1111110000111 "2017-12-04 13:12:04.980" 6 .  .
1111110000111 "2017-12-04 13:13:04.980" 6 .  .
1111110000111 "2017-12-04 13:14:04.980" 6 .  .
1111110000111 "2017-12-04 13:15:04.980" 6 .  .
1111110000111 "2017-12-04 13:16:04.980" 6 .  .
1111110000111 "2017-12-04 13:17:04.980" 1 .  .
1111110000111 "2017-12-04 13:18:04.980" 6 .  .
1111110000111 "2017-12-04 13:19:04.980" 6 .  .
1111110000111 "2017-12-04 13:20:04.980" 6 .  .
1111110000111 "2017-12-04 13:21:04.980" 6 .  .
1111110000111 "2017-12-04 13:22:04.980" 6 .  .
1111110000111 "2017-12-04 13:23:04.980" 6 .  .
1111110000111 "2017-12-04 13:24:04.980" 6 .  .
1111110000111 "2017-12-04 13:25:04.980" 6 .  .
1111110000111 "2017-12-04 13:26:04.980" 6 .  .
1111110000111 "2017-12-04 13:27:04.980" 3 .  .
1111110000111 "2017-12-04 13:28:04.980" 1 .  .
1111110000111 "2017-12-04 13:29:04.980" 6 .  .
1111110000111 "2017-12-04 13:30:04.980" 6 .  .
1111110000111 "2017-12-04 13:31:04.980" 6 .  .
1111110000111 "2017-12-04 13:32:04.980" 6 .  .
1111110000111 "2017-12-04 13:33:04.980" 6 .  .
1111110000111 "2017-12-04 13:34:04.980" 6 .  .
1111110000111 "2017-12-04 13:35:04.980" 6 .  .
1111110000111 "2017-12-04 13:36:04.980" 7 .  .
1111110000111 "2017-12-04 13:37:04.980" 6 .  .
1111110000111 "2017-12-04 13:38:04.980" 6 .  .
1111110000111 "2017-12-04 13:39:04.980" 1 .  .
1111110000111 "2017-12-04 13:40:04.980" 6 .  .
1111110000111 "2017-12-04 13:41:04.980" 6 .  .
1111110000111 "2017-12-04 13:42:04.980" 6 .  .
1111110000111 "2017-12-04 13:43:04.980" 6 .  .
1111110000111 "2017-12-04 13:44:04.980" 6 .  .
1111110000111 "2017-12-04 13:45:04.980" 7 .  .
1111110000111 "2017-12-04 13:46:04.980" 6 .  .
1111110000111 "2017-12-04 13:47:04.980" 6 .  .
1111110000111 "2017-12-04 13:48:04.980" 6 .  .
1111110000111 "2017-12-04 13:49:04.980" 6 .  .
1111110000111 "2017-12-04 13:50:04.980" 6 .  .
1111110000111 "2017-12-04 13:51:04.980" 6 .  .
1111110000111 "2017-12-04 13:52:04.980" 6 .  .
1111110000111 "2017-12-04 13:53:04.980" 6 .  .
1111110000111 "2017-12-04 13:54:04.980" 6 .  .
1111110000111 "2017-12-04 13:55:04.980" 6 .  .
1111110000111 "2017-12-04 13:56:04.980" 6 .  .
1111110000111 "2017-12-04 13:57:04.980" 1 .  .
1111110000111 "2017-12-04 13:58:04.980" 6 .  .
1111110000111 "2017-12-04 13:59:04.980" 6 .  .
1111110000111 "2017-12-04 14:00:04.980" 6 .  .
1111110000111 "2017-12-04 14:01:04.980" 6 .  .
1111110000111 "2017-12-04 14:02:04.980" 6 .  .
1111110000111 "2017-12-04 14:03:04.980" 8 .  .
1111110000111 "2017-12-04 14:04:04.980" 8 .  .
1111110000111 "2017-12-04 14:05:04.980" 8 .  .
1111110000111 "2017-12-04 14:06:04.980" 6 .  .
1111110000111 "2017-12-04 14:07:04.980" 6 .  .
1111110000111 "2017-12-04 14:08:04.980" 6 .  .
1111110000111 "2017-12-04 14:09:04.980" 6 .  .
1111110000111 "2017-12-04 14:10:04.980" 1 .  .
1111110000111 "2017-12-04 14:11:04.980" 1 .  .
1111110000111 "2017-12-04 14:12:04.980" 7 .  .
1111110000111 "2017-12-04 14:13:04.980" 7 .  .
1111110000111 "2017-12-04 14:14:04.980" 7 .  .
1111110000111 "2017-12-04 14:15:04.980" 7 .  .
1111110000111 "2017-12-04 14:16:04.980" 7 .  .
1111110000111 "2017-12-04 14:17:04.980" 7 .  .
1111110000111 "2017-12-04 14:18:04.980" 6 .  .
1111110000111 "2017-12-04 14:19:04.980" 7 .  .
1111110000111 "2017-12-04 14:20:04.980" 6 .  .
1111110000111 "2017-12-04 14:21:04.980" 6 .  .
1111110000111 "2017-12-04 14:22:04.980" 7 .  .
1111110000111 "2017-12-04 14:23:04.980" 7 .  .
1111110000111 "2017-12-04 14:24:04.980" 2 .  .
1111110000111 "2017-12-04 14:25:04.980" 1 .  .
1111110000111 "2017-12-04 14:26:04.980" 8 .  .
1111110000111 "2017-12-04 14:27:04.980" 8 .  .
1111110000111 "2017-12-04 14:28:04.980" 8 .  .
1111110000111 "2017-12-04 14:29:04.980" 8 .  .
1111110000111 "2017-12-04 14:30:04.980" 8 .  .
1111110000111 "2017-12-04 14:31:04.980" 8 .  .
1111110000111 "2017-12-04 14:32:04.980" 8 .  .
1111110000111 "2017-12-04 14:33:04.980" 8 .  .
1111110000111 "2017-12-04 14:34:04.980" 8 .  .
1111110000111 "2017-12-04 14:35:04.980" 8 .  .
1111110000111 "2017-12-04 14:36:04.980" 8 .  .
1111110000111 "2017-12-04 14:37:04.980" 8 .  .
1111110000111 "2017-12-04 14:38:04.980" 8 .  .
1111110000111 "2017-12-04 14:39:04.980" 8 .  .
1111110000111 "2017-12-04 14:40:04.980" 8 .  .
1111110000111 "2017-12-04 14:41:04.980" 8 .  .
1111110000111 "2017-12-04 14:42:04.980" 8 .  .
1111110000111 "2017-12-04 14:43:04.980" 8 .  .
1111110000111 "2017-12-04 14:44:04.980" 8 .  .
1111110000111 "2017-12-04 14:45:04.980" 8 .  .
1111110000111 "2017-12-04 14:46:04.980" 8 .  .
1111110000111 "2017-12-04 14:47:04.980" 8 .  .
1111110000111 "2017-12-04 14:48:04.980" 8 .  .
1111110000111 "2017-12-04 14:49:04.980" 8 .  .
1111110000111 "2017-12-04 14:50:04.980" 8 .  .
1111110000111 "2017-12-04 14:51:04.980" 8 .  .
1111110000111 "2017-12-04 14:52:04.980" 8 .  .
1111110000111 "2017-12-04 14:53:04.980" 8 .  .
1111110000111 "2017-12-04 14:54:04.980" 8 .  .
1111110000111 "2017-12-04 14:55:04.980" 8 .  .
1111110000111 "2017-12-04 14:56:04.980" 8 .  .
1111110000111 "2017-12-04 14:57:04.980" 8 .  .
1111110000111 "2017-12-04 14:58:04.980" 8 .  .
1111110000111 "2017-12-04 14:59:04.980" 8 .  .
1111110000111 "2017-12-04 15:00:04.980" 8 . 15
1111110000111 "2017-12-04 15:01:04.980" 8 .  .
1111110000111 "2017-12-04 15:02:04.980" 8 .  .
1111110000111 "2017-12-04 15:03:04.980" 8 .  .
1111110000111 "2017-12-04 15:04:04.980" 8 .  .
1111110000111 "2017-12-04 15:05:04.980" 8 .  .
1111110000111 "2017-12-04 15:06:04.980" 8 .  .
1111110000111 "2017-12-04 15:07:04.980" 7 .  .
1111110000111 "2017-12-04 15:08:04.980" 6 .  .
1111110000111 "2017-12-04 15:09:04.980" 6 .  .
1111110000111 "2017-12-04 15:10:04.980" 6 .  .
1111110000111 "2017-12-04 15:11:04.980" 1 .  .
1111110000111 "2017-12-04 15:12:04.980" 1 .  .
1111110000111 "2017-12-04 15:13:04.980" 7 .  .
1111110000111 "2017-12-04 15:14:04.980" 7 .  .
1111110000111 "2017-12-04 15:15:04.980" 7 .  .
1111110000111 "2017-12-04 15:16:04.980" 7 .  .
1111110000111 "2017-12-04 15:17:04.980" 7 .  .
1111110000111 "2017-12-04 15:18:04.980" 7 .  .
1111110000111 "2017-12-04 15:19:04.980" 7 .  .
end

[Andrew Musau]

The retrospective fix does not work, as this person worked from 8 to 13 the first day (14.03.2018), but did not work at all the next day (15.03.2018).

The data example that you presented in #7 does not include these dates.

[Atle Kongsvold]

The exact dates does not matter, as it is the same for all participants. However, below I attached data from the same participant and dates. I had to cut out a few hours in the middle as it is max 30000 characters in a post.

* Example generated by -dataex-. To install: ssc install dataex
clear
input double participant_id str23 timestamp int activity float(start_clock end_clock)
1111110000112 "2018-03-14 08:00:04.980"   6 8  .
1111110000112 "2018-03-14 08:01:04.980"   6 .  .
1111110000112 "2018-03-14 08:02:04.980"   6 .  .
1111110000112 "2018-03-14 08:03:04.980"   6 .  .
1111110000112 "2018-03-14 08:04:04.980"   6 .  .
1111110000112 "2018-03-14 08:05:04.980"   6 .  .
1111110000112 "2018-03-14 08:06:04.980"   6 .  .
1111110000112 "2018-03-14 08:07:04.980"   1 .  .
1111110000112 "2018-03-14 08:08:04.980"   6 .  .
1111110000112 "2018-03-14 08:09:04.980"   6 .  .
1111110000112 "2018-03-14 08:10:04.980"   6 .  .
1111110000112 "2018-03-14 08:11:04.980"   6 .  .
1111110000112 "2018-03-14 08:12:04.980"   1 .  .
1111110000112 "2018-03-14 08:13:04.980"   6 .  .
1111110000112 "2018-03-14 08:14:04.980"   7 .  .
1111110000112 "2018-03-14 08:15:04.980"   7 .  .
1111110000112 "2018-03-14 08:16:04.980"   6 .  .
1111110000112 "2018-03-14 08:17:04.980"   6 .  .
1111110000112 "2018-03-14 08:18:04.980"   6 .  .
1111110000112 "2018-03-14 08:19:04.980"   6 .  .
1111110000112 "2018-03-14 08:20:04.980"   6 .  .
1111110000112 "2018-03-14 08:21:04.980"   6 .  .
1111110000112 "2018-03-14 08:22:04.980"   6 .  .
1111110000112 "2018-03-14 08:23:04.980"   3 .  .
1111110000112 "2018-03-14 08:24:04.980"   6 .  .
1111110000112 "2018-03-14 08:25:04.980"   6 .  .
1111110000112 "2018-03-14 08:26:04.980"   6 .  .
1111110000112 "2018-03-14 08:27:04.980"   6 .  .
1111110000112 "2018-03-14 08:28:04.980"   6 .  .
1111110000112 "2018-03-14 08:29:04.980"   6 .  .
1111110000112 "2018-03-14 08:30:04.980"   6 .  .
1111110000112 "2018-03-14 08:31:04.980"   6 .  .
1111110000112 "2018-03-14 08:32:04.980"   1 .  .
1111110000112 "2018-03-14 08:33:04.980"   6 .  .
1111110000112 "2018-03-14 08:34:04.980"   6 .  .
1111110000112 "2018-03-14 08:35:04.980"   6 .  .
1111110000112 "2018-03-14 08:36:04.980"   6 .  .
1111110000112 "2018-03-14 08:37:04.980"   6 .  .
1111110000112 "2018-03-14 08:38:04.980"   6 .  .
1111110000112 "2018-03-14 08:39:04.980"   7 .  .
1111110000112 "2018-03-14 08:40:04.980"   1 .  .
1111110000112 "2018-03-14 08:41:04.980"   6 .  .
1111110000112 "2018-03-14 08:42:04.980"   6 .  .
1111110000112 "2018-03-14 08:43:04.980"   6 .  .
1111110000112 "2018-03-14 08:44:04.980"   6 .  .
1111110000112 "2018-03-14 08:45:04.980"   6 .  .
1111110000112 "2018-03-14 08:46:04.980"   6 .  .
1111110000112 "2018-03-14 08:47:04.980"   6 .  .
1111110000112 "2018-03-14 08:48:04.980"   6 .  .
1111110000112 "2018-03-14 08:49:04.980"   6 .  .
1111110000112 "2018-03-14 08:50:04.980"   6 .  .
1111110000112 "2018-03-14 08:51:04.980"   6 .  .
1111110000112 "2018-03-14 08:52:04.980"   6 .  .
1111110000112 "2018-03-14 08:53:04.980"   6 .  .
1111110000112 "2018-03-14 08:54:04.980"   1 .  .
1111110000112 "2018-03-14 08:55:04.980"   6 .  .
1111110000112 "2018-03-14 08:56:04.980"   7 .  .
1111110000112 "2018-03-14 08:57:04.980"   7 .  .
1111110000112 "2018-03-14 08:58:04.980"   7 .  .
1111110000112 "2018-03-14 08:59:04.980"   7 .  .
1111110000112 "2018-03-14 09:00:04.980"   7 .  .
1111110000112 "2018-03-14 09:01:04.980"   7 .  .
1111110000112 "2018-03-14 09:02:04.980"   7 .  .
1111110000112 "2018-03-14 09:03:04.980"   6 .  .
1111110000112 "2018-03-14 09:04:04.980"   7 .  .
1111110000112 "2018-03-14 09:05:04.980"   7 .  .
1111110000112 "2018-03-14 09:06:04.980"   7 .  .
1111110000112 "2018-03-14 09:07:04.980"   7 .  .
1111110000112 "2018-03-14 09:08:04.980"   7 .  .
1111110000112 "2018-03-14 09:09:04.980"   7 .  .
1111110000112 "2018-03-14 09:10:04.980"   7 .  .
1111110000112 "2018-03-14 09:11:04.980"   7 .  .
1111110000112 "2018-03-14 09:12:04.980"   6 .  .
1111110000112 "2018-03-14 09:13:04.980"   6 .  .
1111110000112 "2018-03-14 09:14:04.980"   6 .  .
1111110000112 "2018-03-14 09:15:04.980"   6 .  .
1111110000112 "2018-03-14 09:16:04.980"   6 .  .
1111110000112 "2018-03-14 09:17:04.980"   6 .  .
1111110000112 "2018-03-14 09:18:04.980"   6 .  .
1111110000112 "2018-03-14 09:19:04.980"   6 .  .
1111110000112 "2018-03-14 09:20:04.980"   6 .  .
1111110000112 "2018-03-14 09:21:04.980"   6 .  .
1111110000112 "2018-03-14 09:22:04.980"   6 .  .
1111110000112 "2018-03-14 09:23:04.980"   6 .  .
1111110000112 "2018-03-14 09:24:04.980"   6 .  .
1111110000112 "2018-03-14 09:25:04.980"   6 .  .
1111110000112 "2018-03-14 09:26:04.980"   6 .  .
1111110000112 "2018-03-14 09:27:04.980"   6 .  .
1111110000112 "2018-03-14 09:28:04.980"   6 .  .
1111110000112 "2018-03-14 09:29:04.980"   6 .  .
1111110000112 "2018-03-14 09:30:04.980"   6 .  .
1111110000112 "2018-03-14 09:31:04.980"   6 .  .
1111110000112 "2018-03-14 09:32:04.980"   6 .  .
1111110000112 "2018-03-14 09:33:04.980"   6 .  .
1111110000112 "2018-03-14 09:34:04.980"   6 .  .
1111110000112 "2018-03-14 09:35:04.980"   6 .  .
1111110000112 "2018-03-14 09:36:04.980"   6 .  .
1111110000112 "2018-03-14 09:37:04.980"   1 .  .
1111110000112 "2018-03-14 09:38:04.980"   6 .  .
1111110000112 "2018-03-14 09:39:04.980"   6 .  .
1111110000112 "2018-03-14 09:40:04.980"   6 .  .
1111110000112 "2018-03-14 09:41:04.980"   6 .  .
1111110000112 "2018-03-14 09:42:04.980"   6 .  .
1111110000112 "2018-03-14 09:43:04.980"   6 .  .
1111110000112 "2018-03-14 09:44:04.980"   6 .  .
1111110000112 "2018-03-14 09:45:04.980"   6 .  .
1111110000112 "2018-03-14 09:46:04.980"   6 .  .
1111110000112 "2018-03-14 09:47:04.980"   6 .  .
1111110000112 "2018-03-14 09:48:04.980"   6 .  .
1111110000112 "2018-03-14 09:49:04.980"   6 .  .
1111110000112 "2018-03-14 09:50:04.980"   6 .  .
1111110000112 "2018-03-14 09:51:04.980"   6 .  .
1111110000112 "2018-03-14 09:52:04.980"   6 .  .
1111110000112 "2018-03-14 09:53:04.980"   6 .  .
1111110000112 "2018-03-14 09:54:04.980"   1 .  .
1111110000112 "2018-03-14 09:55:04.980"   6 .  .
1111110000112 "2018-03-14 09:56:04.980"   6 .  .
1111110000112 "2018-03-14 09:57:04.980"   6 .  .
1111110000112 "2018-03-14 09:58:04.980"   6 .  .
1111110000112 "2018-03-14 09:59:04.980"   6 .  .
1111110000112 "2018-03-14 10:00:04.980"   6 .  .
1111110000112 "2018-03-14 10:01:04.980"   6 .  .
1111110000112 "2018-03-14 10:02:04.980"   6 .  .
1111110000112 "2018-03-14 10:03:04.980"   6 .  .
1111110000112 "2018-03-14 10:04:04.980"   6 .  .
1111110000112 "2018-03-14 10:05:04.980"   6 .  .
1111110000112 "2018-03-14 10:06:04.980"   6 .  .
1111110000112 "2018-03-14 10:07:04.980"   6 .  .
1111110000112 "2018-03-14 10:08:04.980"   6 .  .
1111110000112 "2018-03-14 10:09:04.980"   6 .  .
1111110000112 "2018-03-14 10:10:04.980"   6 .  .
1111110000112 "2018-03-14 10:11:04.980"   6 .  .
1111110000112 "2018-03-14 10:12:04.980"   6 .  .
1111110000112 "2018-03-14 10:13:04.980"   6 .  .
1111110000112 "2018-03-14 10:14:04.980"   6 .  .
1111110000112 "2018-03-14 10:15:04.980"   6 .  .
1111110000112 "2018-03-14 10:16:04.980"   1 .  .
1111110000112 "2018-03-14 10:17:04.980"   6 .  .
1111110000112 "2018-03-14 10:18:04.980"   6 .  .
1111110000112 "2018-03-14 10:19:04.980"   6 .  .
1111110000112 "2018-03-14 10:20:04.980"   6 .  .
1111110000112 "2018-03-14 10:21:04.980"   6 .  .
1111110000112 "2018-03-14 10:22:04.980"   6 .  .
1111110000112 "2018-03-14 10:23:04.980"   6 .  .
1111110000112 "2018-03-14 10:24:04.980"   6 .  .
1111110000112 "2018-03-14 10:25:04.980"   6 .  .
1111110000112 "2018-03-14 10:26:04.980"   6 .  .
1111110000112 "2018-03-14 10:27:04.980"   6 .  .
1111110000112 "2018-03-14 10:28:04.980"   6 .  .
1111110000112 "2018-03-14 10:29:04.980"   6 .  .
1111110000112 "2018-03-14 10:30:04.980"   6 .  .
1111110000112 "2018-03-14 10:31:04.980"   6 .  .
1111110000112 "2018-03-14 10:32:04.980"   1 .  .
1111110000112 "2018-03-14 10:33:04.980"   6 .  .
1111110000112 "2018-03-14 10:34:04.980"   6 .  .
1111110000112 "2018-03-14 10:35:04.980"   6 .  .
1111110000112 "2018-03-14 10:36:04.980"   6 .  .
1111110000112 "2018-03-14 10:37:04.980"   6 .  .
1111110000112 "2018-03-14 10:38:04.980"   6 .  .
1111110000112 "2018-03-14 10:39:04.980"   6 .  .
1111110000112 "2018-03-14 10:40:04.980"   6 .  .
1111110000112 "2018-03-14 10:41:04.980"   6 .  .
1111110000112 "2018-03-14 10:42:04.980"   6 .  .
1111110000112 "2018-03-14 10:43:04.980"   6 .  .
1111110000112 "2018-03-14 10:44:04.980"   6 .  .
1111110000112 "2018-03-14 10:45:04.980"   1 .  .
1111110000112 "2018-03-14 10:46:04.980"   6 .  .
1111110000112 "2018-03-14 10:47:04.980"   6 .  .
1111110000112 "2018-03-14 10:48:04.980"   6 .  .
1111110000112 "2018-03-14 10:49:04.980"   6 .  .
1111110000112 "2018-03-14 10:50:04.980"   6 .  .
1111110000112 "2018-03-14 10:51:04.980"   6 .  .
1111110000112 "2018-03-14 10:52:04.980"   6 .  .
1111110000112 "2018-03-14 10:53:04.980"   6 .  .
1111110000112 "2018-03-14 10:54:04.980"   6 .  .
1111110000112 "2018-03-14 10:55:04.980"   6 .  .
1111110000112 "2018-03-14 10:56:04.980"   6 .  .
1111110000112 "2018-03-14 10:57:04.980"   6 .  .
1111110000112 "2018-03-14 10:58:04.980"   6 .  .
1111110000112 "2018-03-14 10:59:04.980"   6 .  .
1111110000112 "2018-03-14 11:00:04.980"   6 .  .
1111110000112 "2018-03-14 11:01:04.980"   6 .  .
1111110000112 "2018-03-14 11:02:04.980"   1 .  .
1111110000112 "2018-03-14 11:03:04.980"   6 .  .
1111110000112 "2018-03-14 11:04:04.980"   6 .  .
1111110000112 "2018-03-14 11:05:04.980"   6 .  .
1111110000112 "2018-03-14 11:06:04.980"   6 .  .
1111110000112 "2018-03-14 11:07:04.980"   6 .  .
1111110000112 "2018-03-14 11:08:04.980"   6 .  .
1111110000112 "2018-03-14 11:09:04.980"   6 .  .
1111110000112 "2018-03-14 11:10:04.980"   6 .  .
1111110000112 "2018-03-14 11:11:04.980"   6 .  .
1111110000112 "2018-03-14 11:12:04.980"   6 .  .
1111110000112 "2018-03-14 11:13:04.980"   6 .  .
1111110000112 "2018-03-14 11:14:04.980"   1 .  .
1111110000112 "2018-03-14 11:15:04.980"   6 .  .
1111110000112 "2018-03-14 11:16:04.980"   6 .  .
1111110000112 "2018-03-14 11:17:04.980"   6 .  .
1111110000112 "2018-03-14 11:18:04.980"   1 .  .
1111110000112 "2018-03-14 11:19:04.980"   6 .  .
1111110000112 "2018-03-14 11:20:04.980"   6 .  .
1111110000112 "2018-03-14 11:21:04.980"   6 .  .
1111110000112 "2018-03-14 11:22:04.980"   6 .  .
1111110000112 "2018-03-14 11:23:04.980"   6 .  .
1111110000112 "2018-03-14 11:24:04.980"   6 .  .
1111110000112 "2018-03-14 11:25:04.980"   6 .  .
1111110000112 "2018-03-14 11:26:04.980"   6 .  .
1111110000112 "2018-03-14 11:27:04.980"   6 .  .
1111110000112 "2018-03-14 11:28:04.980"   1 .  .
1111110000112 "2018-03-14 11:29:04.980"   6 .  .
1111110000112 "2018-03-14 11:30:04.980"   6 .  .
1111110000112 "2018-03-14 11:31:04.980"   6 .  .
1111110000112 "2018-03-14 11:32:04.980"   6 .  .
1111110000112 "2018-03-14 11:33:04.980"   6 .  .
1111110000112 "2018-03-14 11:34:04.980"   6 .  .
1111110000112 "2018-03-14 11:35:04.980"   6 .  .
1111110000112 "2018-03-14 11:36:04.980"   6 .  .
1111110000112 "2018-03-14 11:37:04.980"   6 .  .
1111110000112 "2018-03-14 11:38:04.980"   6 .  .
1111110000112 "2018-03-14 11:39:04.980"   7 .  .
1111110000112 "2018-03-14 11:40:04.980"   6 .  .
1111110000112 "2018-03-14 11:41:04.980"   6 .  .
1111110000112 "2018-03-14 11:42:04.980"   6 .  .
1111110000112 "2018-03-14 11:43:04.980"   6 .  .
1111110000112 "2018-03-14 11:44:04.980"   6 .  .
1111110000112 "2018-03-14 11:45:04.980"   6 .  .
1111110000112 "2018-03-14 11:46:04.980"   6 .  .
1111110000112 "2018-03-14 11:47:04.980"   7 .  .
1111110000112 "2018-03-14 11:48:04.980"   7 .  .
1111110000112 "2018-03-14 11:49:04.980"   7 .  .
1111110000112 "2018-03-14 11:50:04.980"   7 .  .
1111110000112 "2018-03-14 11:51:04.980"   7 .  .
1111110000112 "2018-03-14 11:52:04.980"   7 .  .
1111110000112 "2018-03-14 11:53:04.980"   7 .  .
1111110000112 "2018-03-14 11:54:04.980"   7 .  .
1111110000112 "2018-03-14 11:55:04.980"   7 .  .
1111110000112 "2018-03-14 11:56:04.980"   7 .  .
1111110000112 "2018-03-14 11:57:04.980"   7 .  .
1111110000112 "2018-03-14 11:58:04.980"   7 .  .
1111110000112 "2018-03-14 11:59:04.980"   7 .  .
1111110000112 "2018-03-14 12:00:04.980"   7 .  .
1111110000112 "2018-03-14 12:01:04.980"   7 .  .
1111110000112 "2018-03-14 12:02:04.980"   7 .  .
1111110000112 "2018-03-14 12:03:04.980"   6 .  .
1111110000112 "2018-03-14 12:04:04.980"   6 .  .
1111110000112 "2018-03-14 12:05:04.980"   6 .  .
1111110000112 "2018-03-14 12:06:04.980"   3 .  .
1111110000112 "2018-03-14 12:07:04.980"   6 .  .
1111110000112 "2018-03-14 12:08:04.980"   7 .  .
1111110000112 "2018-03-14 12:09:04.980"   6 .  .
1111110000112 "2018-03-14 12:10:04.980"   6 .  .
1111110000112 "2018-03-14 12:11:04.980"   6 .  .
1111110000112 "2018-03-14 12:12:04.980"   6 .  .
1111110000112 "2018-03-14 12:13:04.980"   6 .  .
1111110000112 "2018-03-14 12:14:04.980"   6 .  .
1111110000112 "2018-03-14 12:15:04.980"   6 .  .
1111110000112 "2018-03-14 12:16:04.980"   1 .  .
1111110000112 "2018-03-14 12:17:04.980"   6 .  .
1111110000112 "2018-03-14 12:18:04.980"   6 .  .
1111110000112 "2018-03-14 12:19:04.980"   6 .  .
1111110000112 "2018-03-14 12:20:04.980"   6 .  .
1111110000112 "2018-03-14 12:21:04.980"   6 .  .
1111110000112 "2018-03-14 12:22:04.980"   6 .  .
1111110000112 "2018-03-14 12:23:04.980"   1 .  .
1111110000112 "2018-03-14 12:24:04.980"   6 .  .
1111110000112 "2018-03-14 12:25:04.980"   1 .  .
1111110000112 "2018-03-14 12:26:04.980"   6 .  .
1111110000112 "2018-03-14 12:27:04.980"   6 .  .
1111110000112 "2018-03-14 12:28:04.980"   6 .  .
1111110000112 "2018-03-14 12:29:04.980"   1 .  .
1111110000112 "2018-03-14 12:30:04.980"   1 .  .
1111110000112 "2018-03-14 12:31:04.980"   6 .  .
1111110000112 "2018-03-14 12:32:04.980"   1 .  .
1111110000112 "2018-03-14 12:33:04.980"   1 .  .
1111110000112 "2018-03-14 12:34:04.980"   7 .  .
1111110000112 "2018-03-14 12:35:04.980"   7 .  .
1111110000112 "2018-03-14 12:36:04.980"   6 .  .
1111110000112 "2018-03-14 12:37:04.980"   6 .  .
1111110000112 "2018-03-14 12:38:04.980"   6 .  .
1111110000112 "2018-03-14 12:39:04.980"   1 .  .
1111110000112 "2018-03-14 12:40:04.980"   1 .  .
1111110000112 "2018-03-14 12:41:04.980"   1 .  .
1111110000112 "2018-03-14 12:42:04.980"   1 .  .
1111110000112 "2018-03-14 12:43:04.980"   1 .  .
1111110000112 "2018-03-14 12:44:04.980"   1 .  .
1111110000112 "2018-03-14 12:45:04.980"   6 .  .
1111110000112 "2018-03-14 12:46:04.980"   6 .  .
1111110000112 "2018-03-14 12:47:04.980"   1 .  .
1111110000112 "2018-03-14 12:48:04.980"   6 .  .
1111110000112 "2018-03-14 12:49:04.980"   6 .  .
1111110000112 "2018-03-14 12:50:04.980"   6 .  .
1111110000112 "2018-03-14 12:51:04.980"   6 .  .
1111110000112 "2018-03-14 12:52:04.980"   6 .  .
1111110000112 "2018-03-14 12:53:04.980"   6 .  .
1111110000112 "2018-03-14 12:54:04.980"   6 .  .
1111110000112 "2018-03-14 12:55:04.980"   6 .  .
1111110000112 "2018-03-14 12:56:04.980"   6 .  .
1111110000112 "2018-03-14 12:57:04.980"   6 .  .
1111110000112 "2018-03-14 12:58:04.980"   6 .  .
1111110000112 "2018-03-14 12:59:04.980"   6 .  .
1111110000112 "2018-03-14 13:00:04.980"   6 . 13
1111110000112 "2018-03-14 13:01:04.980"   6 .  .
1111110000112 "2018-03-14 13:02:04.980"   1 .  .
1111110000112 "2018-03-14 13:03:04.980"   6 .  .
1111110000112 "2018-03-14 13:04:04.980"   6 .  .
1111110000112 "2018-03-14 13:05:04.980"   6 .  .
1111110000112 "2018-03-14 13:06:04.980"   1 .  .
1111110000112 "2018-03-14 13:07:04.980"   1 .  .
1111110000112 "2018-03-14 13:08:04.980"   1 .  .
1111110000112 "2018-03-14 13:09:04.980"   7 .  .
1111110000112 "2018-03-14 13:10:04.980"   7 .  .
1111110000112 "2018-03-14 13:11:04.980"   7 .  .
1111110000112 "2018-03-14 13:12:04.980"   7 .  .
1111110000112 "2018-03-14 13:13:04.980"   7 .  .
1111110000112 "2018-03-14 13:14:04.980"   7 .  .
1111110000112 "2018-03-14 13:15:04.980"   7 .  .
1111110000112 "2018-03-14 13:16:04.980"   7 .  .
1111110000112 "2018-03-14 13:17:04.980"   7 .  .
1111110000112 "2018-03-14 13:18:04.980"   7 .  .
1111110000112 "2018-03-14 13:19:04.980"   7 .  .
1111110000112 "2018-03-14 13:20:04.980"   7 .  .
1111110000112 "2018-03-14 13:21:04.980"   7 .  .
1111110000112 "2018-03-14 13:22:04.980"   7 .  .
1111110000112 "2018-03-14 13:23:04.980"   7 .  .
1111110000112 "2018-03-14 13:24:04.980"   7 .  .
1111110000112 "2018-03-14 13:25:04.980"   7 .  .
1111110000112 "2018-03-14 13:26:04.980"   7 .  .
1111110000112 "2018-03-14 13:27:04.980"   7 .  .
1111110000112 "2018-03-14 13:28:04.980"   7 .  .
1111110000112 "2018-03-14 13:29:04.980"   7 .  .
1111110000112 "2018-03-14 13:30:04.980"   7 .  .
1111110000112 "2018-03-14 13:31:04.980"   7 .  .
1111110000112 "2018-03-14 13:32:04.980"   7 .  .
1111110000112 "2018-03-14 13:33:04.980"   7 .  .
1111110000112 "2018-03-14 13:34:04.980"   7 .  .
1111110000112 "2018-03-14 13:35:04.980"   7 .  .
1111110000112 "2018-03-14 13:36:04.980"   7 .  .
1111110000112 "2018-03-14 13:37:04.980" 130 .  .
1111110000112 "2018-03-14 13:38:04.980"   7 .  .
1111110000112 "2018-03-14 13:39:04.980"   7 .  .
1111110000112 "2018-03-14 13:40:04.980"   7 .  .
1111110000112 "2018-03-14 13:41:04.980"   7 .  .
1111110000112 "2018-03-14 13:42:04.980"   7 .  .
1111110000112 "2018-03-14 13:43:04.980"   7 .  .
1111110000112 "2018-03-14 13:44:04.980"   7 .  .
1111110000112 "2018-03-14 13:45:04.980"   7 .  .
1111110000112 "2018-03-14 13:46:04.980"   7 .  .
1111110000112 "2018-03-14 13:47:04.980"   7 .  .
1111110000112 "2018-03-14 13:48:04.980"   7 .  .
1111110000112 "2018-03-14 13:49:04.980"   7 .  .
1111110000112 "2018-03-14 13:50:04.980"   7 .  .
1111110000112 "2018-03-14 13:51:04.980"   7 .  .
1111110000112 "2018-03-14 13:52:04.980"   7 .  .
1111110000112 "2018-03-14 13:53:04.980"   7 .  .
1111110000112 "2018-03-14 13:54:04.980"   7 .  .
1111110000112 "2018-03-14 13:55:04.980"   7 .  .
1111110000112 "2018-03-14 13:56:04.980"   7 .  .
1111110000112 "2018-03-14 13:57:04.980"   7 .  .
1111110000112 "2018-03-14 13:58:04.980"   7 .  .
1111110000112 "2018-03-14 13:59:04.980"   7 .  .
1111110000112 "2018-03-14 14:00:04.980"   7 .  .
1111110000112 "2018-03-14 14:01:04.980"   7 .  .
1111110000112 "2018-03-14 14:02:04.980"   7 .  .
1111110000112 "2018-03-14 14:03:04.980"   7 .  .
1111110000112 "2018-03-14 14:04:04.980"   7 .  .
1111110000112 "2018-03-14 14:05:04.980"   7 .  .
1111110000112 "2018-03-14 14:06:04.980"   7 .  .
1111110000112 "2018-03-14 14:07:04.980"   7 .  .
1111110000112 "2018-03-14 14:08:04.980"   7 .  .
1111110000112 "2018-03-14 14:09:04.980"   7 .  .
1111110000112 "2018-03-14 14:10:04.980"   7 .  .
1111110000112 "2018-03-14 14:11:04.980"   7 .  .
1111110000112 "2018-03-14 14:12:04.980"   7 .  .
1111110000112 "2018-03-14 14:13:04.980"   6 .  .
1111110000112 "2018-03-14 14:14:04.980"   6 .  .
1111110000112 "2018-03-14 14:15:04.980"   6 .  .
1111110000112 "2018-03-14 14:16:04.980"   6 .  .
1111110000112 "2018-03-14 14:17:04.980"   6 .  .
1111110000112 "2018-03-14 14:18:04.980"   6 .  .
1111110000112 "2018-03-14 14:19:04.980"   6 .  .
1111110000112 "2018-03-14 14:20:04.980"   6 .  .
1111110000112 "2018-03-14 14:21:04.980"   1 .  .
1111110000112 "2018-03-14 14:22:04.980"   1 .  .
1111110000112 "2018-03-14 14:23:04.980"   6 .  .
1111110000112 "2018-03-14 14:24:04.980"   1 .  .
1111110000112 "2018-03-14 14:25:04.980"   1 .  .
1111110000112 "2018-03-14 14:26:04.980"   1 .  .
1111110000112 "2018-03-14 14:27:04.980"   1 .  .
1111110000112 "2018-03-14 14:28:04.980"   1 .  .
1111110000112 "2018-03-14 14:29:04.980"   1 .  .
1111110000112 "2018-03-14 14:30:04.980"   1 .  .
1111110000112 "2018-03-14 14:31:04.980"   1 .  .
1111110000112 "2018-03-14 14:32:04.980"   1 .  .
1111110000112 "2018-03-14 14:33:04.980"   1 .  .
1111110000112 "2018-03-14 14:34:04.980"   1 .  .
1111110000112 "2018-03-14 14:35:04.980"   1 .  .
1111110000112 "2018-03-14 14:36:04.980"   1 .  .
1111110000112 "2018-03-14 14:37:04.980"   1 .  .
1111110000112 "2018-03-14 14:38:04.980"   1 .  .
1111110000112 "2018-03-14 14:39:04.980"   1 .  .
1111110000112 "2018-03-14 14:40:04.980"   1 .  .
1111110000112 "2018-03-14 14:41:04.980"   1 .  .
1111110000112 "2018-03-14 14:42:04.980"   1 .  .
1111110000112 "2018-03-14 14:43:04.980"   1 .  .
1111110000112 "2018-03-14 14:44:04.980"   1 .  .
1111110000112 "2018-03-14 14:45:04.980"   1 .  .
1111110000112 "2018-03-14 14:46:04.980"   1 .  .
1111110000112 "2018-03-14 14:47:04.980"   1 .  .
1111110000112 "2018-03-14 14:48:04.980"   1 .  .
1111110000112 "2018-03-14 14:49:04.980"   1 .  .
1111110000112 "2018-03-14 14:50:04.980"   1 .  .
1111110000112 "2018-03-14 14:51:04.980"   1 .  .
1111110000112 "2018-03-14 14:52:04.980"   1 .  .
1111110000112 "2018-03-14 14:53:04.980"   1 .  .
1111110000112 "2018-03-14 14:54:04.980"   1 .  .
1111110000112 "2018-03-14 14:55:04.980"   1 .  .
1111110000112 "2018-03-14 14:56:04.980"   1 .  .
1111110000112 "2018-03-14 14:57:04.980"   6 .  .
1111110000112 "2018-03-14 14:58:04.980"   6 .  .
1111110000112 "2018-03-14 14:59:04.980"   6 .  .
1111110000112 "2018-03-14 15:00:04.980"   7 .  .
1111110000112 "2018-03-14 15:01:04.980"   7 .  .
1111110000112 "2018-03-14 15:02:04.980"   7 .  .
1111110000112 "2018-03-14 15:03:04.980"   7 .  .
1111110000112 "2018-03-14 15:04:04.980"   7 .  .
1111110000112 "2018-03-14 15:05:04.980"   7 .  .
1111110000112 "2018-03-14 15:06:04.980"   6 .  .
1111110000112 "2018-03-14 15:07:04.980"   6 .  .
1111110000112 "2018-03-14 15:08:04.980"   6 .  .
1111110000112 "2018-03-14 15:09:04.980"   7 .  .
1111110000112 "2018-03-14 15:10:04.980"   1 .  .
1111110000112 "2018-03-14 15:11:04.980"   7 .  .
1111110000112 "2018-03-14 15:12:04.980"   7 .  .
1111110000112 "2018-03-14 15:13:04.980"   7 .  .
1111110000112 "2018-03-14 15:14:04.980"   7 .  .
1111110000112 "2018-03-14 15:15:04.980"   7 .  .
1111110000112 "2018-03-14 15:16:04.980"   7 .  .
1111110000112 "2018-03-14 15:17:04.980"   7 .  .
1111110000112 "2018-03-14 15:18:04.980"   7 .  .
1111110000112 "2018-03-14 15:19:04.980"   7 .  .
1111110000112 "2018-03-14 15:20:04.980"   7 .  .
1111110000112 "2018-03-14 15:21:04.980"   7 .  .
1111110000112 "2018-03-14 15:22:04.980"   7 .  .
1111110000112 "2018-03-14 15:23:04.980"   7 .  .
1111110000112 "2018-03-14 15:24:04.980"   7 .  .
1111110000112 "2018-03-14 15:25:04.980"   7 .  .
1111110000112 "2018-03-14 15:26:04.980"   7 .  .
1111110000112 "2018-03-14 15:27:04.980"   7 .  .
1111110000112 "2018-03-14 15:28:04.980"   7 .  .
1111110000112 "2018-03-14 15:29:04.980"   7 .  .
1111110000112 "2018-03-14 15:30:04.980"   7 .  .
1111110000112 "2018-03-14 15:31:04.980"   7 .  .
1111110000112 "2018-03-14 15:32:04.980"   7 .  .
1111110000112 "2018-03-14 15:33:04.980"   7 .  .
1111110000112 "2018-03-14 15:34:04.980"   7 .  .
1111110000112 "2018-03-14 15:35:04.980"   6 .  .
1111110000112 "2018-03-14 15:36:04.980"   1 .  .
1111110000112 "2018-03-14 15:37:04.980"   6 .  .
1111110000112 "2018-03-14 15:38:04.980"   6 .  .
1111110000112 "2018-03-14 15:39:04.980"   6 .  .
1111110000112 "2018-03-14 15:40:04.980"   1 .  .
1111110000112 "2018-03-14 15:41:04.980"   6 .  .
1111110000112 "2018-03-14 15:42:04.980"   1 .  .
1111110000112 "2018-03-14 15:43:04.980"   6 .  .
1111110000112 "2018-03-14 15:44:04.980"   1 .  .
1111110000112 "2018-03-14 15:45:04.980"   3 .  .
1111110000112 "2018-03-14 15:46:04.980"   6 .  .
1111110000112 "2018-03-14 15:47:04.980"   1 .  .
1111110000112 "2018-03-14 15:48:04.980"   6 .  .
1111110000112 "2018-03-14 15:49:04.980"   6 .  .
1111110000112 "2018-03-14 15:50:04.980"   6 .  .
1111110000112 "2018-03-14 15:51:04.980"   1 .  .
1111110000112 "2018-03-14 15:52:04.980"   1 .  .
1111110000112 "2018-03-14 15:53:04.980"   1 .  .
1111110000112 "2018-03-14 15:54:04.980"   6 .  .
1111110000112 "2018-03-14 15:55:04.980"   1 .  .
1111110000112 "2018-03-14 15:56:04.980"   7 .  .
1111110000112 "2018-03-14 15:57:04.980"   7 .  .
1111110000112 "2018-03-14 15:58:04.980"   6 .  .
1111110000112 "2018-03-14 15:59:04.980"   3 .  .
1111110000112 "2018-03-14 16:00:04.980"   6 .  .
1111110000112 "2018-03-14 16:01:04.980"   1 .  .
1111110000112 "2018-03-14 16:02:04.980"   1 .  .
1111110000112 "2018-03-14 16:03:04.980"   6 .  .
1111110000112 "2018-03-14 16:04:04.980"   1 .  .
1111110000112 "2018-03-14 16:05:04.980"   6 .  .
1111110000112 "2018-03-14 16:06:04.980"   1 .  .
1111110000112 "2018-03-14 16:07:04.980"   1 .  .
1111110000112 "2018-03-14 16:08:04.980"   1 .  .
1111110000112 "2018-03-14 16:09:04.980"   1 .  .
1111110000112 "2018-03-14 16:10:04.980"   1 .  .
1111110000112 "2018-03-14 16:11:04.980"   1 .  .
1111110000112 "2018-03-14 16:12:04.980"   1 .  .
1111110000112 "2018-03-14 16:13:04.980"   1 .  .
1111110000112 "2018-03-14 16:14:04.980"   6 .  .
1111110000112 "2018-03-14 16:15:04.980"   1 .  .
1111110000112 "2018-03-14 16:16:04.980"   1 .  .
1111110000112 "2018-03-14 16:17:04.980"   1 .  .
1111110000112 "2018-03-14 16:18:04.980"   1 .  .
1111110000112 "2018-03-14 16:19:04.980"   1 .  .
1111110000112 "2018-03-14 16:20:04.980"   1 .  .
1111110000112 "2018-03-14 16:21:04.980"   6 .  .
1111110000112 "2018-03-14 16:22:04.980"   1 .  .
1111110000112 "2018-03-14 16:23:04.980"   1 .  .
1111110000112 "2018-03-14 16:24:04.980"   1 .  .
1111110000112 "2018-03-14 16:25:04.980"   1 .  .
1111110000112 "2018-03-14 16:26:04.980"   1 .  .
1111110000112 "2018-03-14 16:27:04.980"   1 .  .
1111110000112 "2018-03-14 16:28:04.980"   1 .  .
1111110000112 "2018-03-14 16:29:04.980"   1 .  .
1111110000112 "2018-03-14 16:30:04.980"   1 .  .
1111110000112 "2018-03-14 16:31:04.980"   1 .  .
1111110000112 "2018-03-14 16:32:04.980"   1 .  .
1111110000112 "2018-03-14 16:33:04.980"   1 .  .
1111110000112 "2018-03-14 16:34:04.980"   1 .  .
1111110000112 "2018-03-14 16:35:04.980"   1 .  .
1111110000112 "2018-03-14 16:36:04.980"   1 .  .
1111110000112 "2018-03-14 16:37:04.980"   1 .  .
1111110000112 "2018-03-14 16:38:04.980"   6 .  .
1111110000112 "2018-03-14 16:39:04.980"   6 .  .
1111110000112 "2018-03-14 16:40:04.980"   6 .  .
1111110000112 "2018-03-14 16:41:04.980"   6 .  .
1111110000112 "2018-03-14 16:42:04.980"   6 .  .
1111110000112 "2018-03-14 16:43:04.980"   6 .  .
1111110000112 "2018-03-14 16:44:04.980"   6 .  .
1111110000112 "2018-03-14 16:45:04.980"   3 .  .
1111110000112 "2018-03-14 16:46:04.980"   7 .  .
1111110000112 "2018-03-14 16:47:04.980"   7 .  .
1111110000112 "2018-03-14 16:48:04.980"   7 .  .
1111110000112 "2018-03-14 16:49:04.980"   7 .  .
1111110000112 "2018-03-14 16:50:04.980"   7 .  .
1111110000112 "2018-03-14 16:51:04.980"   7 .  .
1111110000112 "2018-03-14 16:52:04.980"   7 .  .
1111110000112 "2018-03-14 16:53:04.980"   7 .  .
1111110000112 "2018-03-14 16:54:04.980"   7 .  .
1111110000112 "2018-03-14 16:55:04.980"   7 .  .
1111110000112 "2018-03-14 16:56:04.980"   7 .  .
1111110000112 "2018-03-14 16:57:04.980"   7 .  .
1111110000112 "2018-03-14 16:58:04.980"   7 .  .
1111110000112 "2018-03-14 16:59:04.980"   7 .  .
1111110000112 "2018-03-15 00:00:04.980"   8 .  .
1111110000112 "2018-03-15 00:01:04.980"   8 .  .
1111110000112 "2018-03-15 00:02:04.980"   8 .  .
1111110000112 "2018-03-15 00:03:04.980"   8 .  .
1111110000112 "2018-03-15 00:04:04.980"   8 .  .
1111110000112 "2018-03-15 00:05:04.980"   8 .  .
1111110000112 "2018-03-15 00:06:04.980"   8 .  .
1111110000112 "2018-03-15 00:07:04.980"   8 .  .
1111110000112 "2018-03-15 00:08:04.980"   8 .  .
1111110000112 "2018-03-15 00:09:04.980"   8 .  .
1111110000112 "2018-03-15 00:10:04.980"   8 .  .
1111110000112 "2018-03-15 00:11:04.980"   8 .  .
1111110000112 "2018-03-15 00:12:04.980"   8 .  .
1111110000112 "2018-03-15 00:13:04.980"   8 .  .
1111110000112 "2018-03-15 00:14:04.980"   8 .  .
1111110000112 "2018-03-15 00:15:04.980"   8 .  .
1111110000112 "2018-03-15 00:16:04.980"   8 .  .
1111110000112 "2018-03-15 00:17:04.980"   8 .  .
1111110000112 "2018-03-15 00:18:04.980"   8 .  .
1111110000112 "2018-03-15 00:19:04.980"   8 .  .
1111110000112 "2018-03-15 00:20:04.980"   8 .  .
1111110000112 "2018-03-15 00:21:04.980"   8 .  .
1111110000112 "2018-03-15 00:22:04.980"   8 .  .
1111110000112 "2018-03-15 00:23:04.980"   8 .  .
1111110000112 "2018-03-15 00:24:04.980"   8 .  .
1111110000112 "2018-03-15 00:25:04.980"   8 .  .
1111110000112 "2018-03-15 00:26:04.980"   8 .  .
1111110000112 "2018-03-15 00:27:04.980"   8 .  .
1111110000112 "2018-03-15 00:28:04.980"   8 .  .
1111110000112 "2018-03-15 00:29:04.980"   8 .  .
1111110000112 "2018-03-15 00:30:04.980"   8 .  .
1111110000112 "2018-03-15 00:31:04.980"   8 .  .
1111110000112 "2018-03-15 00:32:04.980"   8 .  .
1111110000112 "2018-03-15 00:33:04.980"   8 .  .
1111110000112 "2018-03-15 00:34:04.980"   8 .  .
1111110000112 "2018-03-15 00:35:04.980"   8 .  .
1111110000112 "2018-03-15 00:36:04.980"   8 .  .
1111110000112 "2018-03-15 00:37:04.980"   8 .  .
1111110000112 "2018-03-15 00:38:04.980"   8 .  .
1111110000112 "2018-03-15 00:39:04.980"   8 .  .
1111110000112 "2018-03-15 00:40:04.980"   8 .  .
1111110000112 "2018-03-15 00:41:04.980"   8 .  .
1111110000112 "2018-03-15 00:42:04.980"   8 .  .
1111110000112 "2018-03-15 00:43:04.980"   8 .  .
1111110000112 "2018-03-15 00:44:04.980"   8 .  .
1111110000112 "2018-03-15 00:45:04.980"   8 .  .
1111110000112 "2018-03-15 00:46:04.980"   8 .  .
1111110000112 "2018-03-15 00:47:04.980"   8 .  .
1111110000112 "2018-03-15 00:48:04.980"   8 .  .
1111110000112 "2018-03-15 00:49:04.980"   8 .  .
1111110000112 "2018-03-15 00:50:04.980"   8 .  .
1111110000112 "2018-03-15 00:51:04.980"   8 .  .
1111110000112 "2018-03-15 00:52:04.980"   8 .  .
1111110000112 "2018-03-15 00:53:04.980"   8 .  .
1111110000112 "2018-03-15 00:54:04.980"   8 .  .
1111110000112 "2018-03-15 00:55:04.980"   8 .  .
1111110000112 "2018-03-15 00:56:04.980"   8 .  .
1111110000112 "2018-03-15 00:57:04.980"   8 .  .
1111110000112 "2018-03-15 00:58:04.980"   8 .  .
1111110000112 "2018-03-15 00:59:04.980"   8 .  .
1111110000112 "2018-03-15 01:00:04.980"   8 .  .
end

[Andrew Musau]

There is really no consistency in the data examples that you are presenting. The string time stamp variable is format DMY in #1 and YMD in your current example. But I see the issue. The tagged date does not necessarily occur at the last observation having that date. You therefore need to distribute the value across all observations having that date.

replace timestamp= ustrregexra(timestamp, "(.*)(\.\d+$)", "$1")
gen double time= clock(timestamp, "YMDhms")
format time %tc
gen date= dofc(time)
gen hr= real(ustrregexra(timestamp, ".*\s(\d{2}):.*", "$1"))
bys participant_id date hr (end_clock): replace end_clock= end_clock[1]
bys participant_id date hr (start_clock): replace start_clock= start_clock[1]
gsort participant_id -time
by participant_id: replace end_clock= end_clock[_n-1] if !missing(end_clock[_n-1]) & missing(end_clock)
sort participant_id time
by participant_id: replace start_clock= start_clock[_n-1] if !missing(start_clock[_n-1]) & missing(start_clock) & end_clock== end_clock[_n-1]
replace end_clock= . if missing(start_clock)
gen wanted= !missing(start_clock)

Res.:

. l if inrange(_n, 1, 30)|inrange(_n, 340, 390) , sep(0)

     +-----------------------------------------------------------------------------------------------------------------+
     | participant~d             timestamp   activity   start_~k   end_cl~k                 time    date   hr   wanted |
     |-----------------------------------------------------------------------------------------------------------------|
  1. | 1111110000112   2018-03-14 08:00:04          6          8         13   14mar2018 08:00:04   21257    8        1 |
  2. | 1111110000112   2018-03-14 08:01:04          6          8         13   14mar2018 08:01:04   21257    8        1 |
  3. | 1111110000112   2018-03-14 08:02:04          6          8         13   14mar2018 08:02:04   21257    8        1 |
  4. | 1111110000112   2018-03-14 08:03:04          6          8         13   14mar2018 08:03:04   21257    8        1 |
  5. | 1111110000112   2018-03-14 08:04:04          6          8         13   14mar2018 08:04:04   21257    8        1 |
  6. | 1111110000112   2018-03-14 08:05:04          6          8         13   14mar2018 08:05:04   21257    8        1 |
  7. | 1111110000112   2018-03-14 08:06:04          6          8         13   14mar2018 08:06:04   21257    8        1 |
  8. | 1111110000112   2018-03-14 08:07:04          1          8         13   14mar2018 08:07:04   21257    8        1 |
  9. | 1111110000112   2018-03-14 08:08:04          6          8         13   14mar2018 08:08:04   21257    8        1 |
 10. | 1111110000112   2018-03-14 08:09:04          6          8         13   14mar2018 08:09:04   21257    8        1 |
 11. | 1111110000112   2018-03-14 08:10:04          6          8         13   14mar2018 08:10:04   21257    8        1 |
 12. | 1111110000112   2018-03-14 08:11:04          6          8         13   14mar2018 08:11:04   21257    8        1 |
 13. | 1111110000112   2018-03-14 08:12:04          1          8         13   14mar2018 08:12:04   21257    8        1 |
 14. | 1111110000112   2018-03-14 08:13:04          6          8         13   14mar2018 08:13:04   21257    8        1 |
 15. | 1111110000112   2018-03-14 08:14:04          7          8         13   14mar2018 08:14:04   21257    8        1 |
 16. | 1111110000112   2018-03-14 08:15:04          7          8         13   14mar2018 08:15:04   21257    8        1 |
 17. | 1111110000112   2018-03-14 08:16:04          6          8         13   14mar2018 08:16:04   21257    8        1 |
 18. | 1111110000112   2018-03-14 08:17:04          6          8         13   14mar2018 08:17:04   21257    8        1 |
 19. | 1111110000112   2018-03-14 08:18:04          6          8         13   14mar2018 08:18:04   21257    8        1 |
 20. | 1111110000112   2018-03-14 08:19:04          6          8         13   14mar2018 08:19:04   21257    8        1 |
 21. | 1111110000112   2018-03-14 08:20:04          6          8         13   14mar2018 08:20:04   21257    8        1 |
 22. | 1111110000112   2018-03-14 08:21:04          6          8         13   14mar2018 08:21:04   21257    8        1 |
 23. | 1111110000112   2018-03-14 08:22:04          6          8         13   14mar2018 08:22:04   21257    8        1 |
 24. | 1111110000112   2018-03-14 08:23:04          3          8         13   14mar2018 08:23:04   21257    8        1 |
 25. | 1111110000112   2018-03-14 08:24:04          6          8         13   14mar2018 08:24:04   21257    8        1 |
 26. | 1111110000112   2018-03-14 08:25:04          6          8         13   14mar2018 08:25:04   21257    8        1 |
 27. | 1111110000112   2018-03-14 08:26:04          6          8         13   14mar2018 08:26:04   21257    8        1 |
 28. | 1111110000112   2018-03-14 08:27:04          6          8         13   14mar2018 08:27:04   21257    8        1 |
 29. | 1111110000112   2018-03-14 08:28:04          6          8         13   14mar2018 08:28:04   21257    8        1 |
 30. | 1111110000112   2018-03-14 08:29:04          6          8         13   14mar2018 08:29:04   21257    8        1 |
340. | 1111110000112   2018-03-14 13:39:04          7          8         13   14mar2018 13:39:04   21257   13        1 |
341. | 1111110000112   2018-03-14 13:40:04          7          8         13   14mar2018 13:40:04   21257   13        1 |
342. | 1111110000112   2018-03-14 13:41:04          7          8         13   14mar2018 13:41:04   21257   13        1 |
343. | 1111110000112   2018-03-14 13:42:04          7          8         13   14mar2018 13:42:04   21257   13        1 |
344. | 1111110000112   2018-03-14 13:43:04          7          8         13   14mar2018 13:43:04   21257   13        1 |
345. | 1111110000112   2018-03-14 13:44:04          7          8         13   14mar2018 13:44:04   21257   13        1 |
346. | 1111110000112   2018-03-14 13:45:04          7          8         13   14mar2018 13:45:04   21257   13        1 |
347. | 1111110000112   2018-03-14 13:46:04          7          8         13   14mar2018 13:46:04   21257   13        1 |
348. | 1111110000112   2018-03-14 13:47:04          7          8         13   14mar2018 13:47:04   21257   13        1 |
349. | 1111110000112   2018-03-14 13:48:04          7          8         13   14mar2018 13:48:04   21257   13        1 |
350. | 1111110000112   2018-03-14 13:49:04          7          8         13   14mar2018 13:49:04   21257   13        1 |
351. | 1111110000112   2018-03-14 13:50:04          7          8         13   14mar2018 13:50:04   21257   13        1 |
352. | 1111110000112   2018-03-14 13:51:04          7          8         13   14mar2018 13:51:04   21257   13        1 |
353. | 1111110000112   2018-03-14 13:52:04          7          8         13   14mar2018 13:52:04   21257   13        1 |
354. | 1111110000112   2018-03-14 13:53:04          7          8         13   14mar2018 13:53:04   21257   13        1 |
355. | 1111110000112   2018-03-14 13:54:04          7          8         13   14mar2018 13:54:04   21257   13        1 |
356. | 1111110000112   2018-03-14 13:55:04          7          8         13   14mar2018 13:55:04   21257   13        1 |
357. | 1111110000112   2018-03-14 13:56:04          7          8         13   14mar2018 13:56:04   21257   13        1 |
358. | 1111110000112   2018-03-14 13:57:04          7          8         13   14mar2018 13:57:04   21257   13        1 |
359. | 1111110000112   2018-03-14 13:58:04          7          8         13   14mar2018 13:58:04   21257   13        1 |
360. | 1111110000112   2018-03-14 13:59:04          7          8         13   14mar2018 13:59:04   21257   13        1 |
361. | 1111110000112   2018-03-14 14:00:04          7          .          .   14mar2018 14:00:04   21257   14        0 |
362. | 1111110000112   2018-03-14 14:01:04          7          .          .   14mar2018 14:01:04   21257   14        0 |
363. | 1111110000112   2018-03-14 14:02:04          7          .          .   14mar2018 14:02:04   21257   14        0 |
364. | 1111110000112   2018-03-14 14:03:04          7          .          .   14mar2018 14:03:04   21257   14        0 |
365. | 1111110000112   2018-03-14 14:04:04          7          .          .   14mar2018 14:04:04   21257   14        0 |
366. | 1111110000112   2018-03-14 14:05:04          7          .          .   14mar2018 14:05:04   21257   14        0 |
367. | 1111110000112   2018-03-14 14:06:04          7          .          .   14mar2018 14:06:04   21257   14        0 |
368. | 1111110000112   2018-03-14 14:07:04          7          .          .   14mar2018 14:07:04   21257   14        0 |
369. | 1111110000112   2018-03-14 14:08:04          7          .          .   14mar2018 14:08:04   21257   14        0 |
370. | 1111110000112   2018-03-14 14:09:04          7          .          .   14mar2018 14:09:04   21257   14        0 |
371. | 1111110000112   2018-03-14 14:10:04          7          .          .   14mar2018 14:10:04   21257   14        0 |
372. | 1111110000112   2018-03-14 14:11:04          7          .          .   14mar2018 14:11:04   21257   14        0 |
373. | 1111110000112   2018-03-14 14:12:04          7          .          .   14mar2018 14:12:04   21257   14        0 |
374. | 1111110000112   2018-03-14 14:13:04          6          .          .   14mar2018 14:13:04   21257   14        0 |
375. | 1111110000112   2018-03-14 14:14:04          6          .          .   14mar2018 14:14:04   21257   14        0 |
376. | 1111110000112   2018-03-14 14:15:04          6          .          .   14mar2018 14:15:04   21257   14        0 |
377. | 1111110000112   2018-03-14 14:16:04          6          .          .   14mar2018 14:16:04   21257   14        0 |
378. | 1111110000112   2018-03-14 14:17:04          6          .          .   14mar2018 14:17:04   21257   14        0 |
379. | 1111110000112   2018-03-14 14:18:04          6          .          .   14mar2018 14:18:04   21257   14        0 |
380. | 1111110000112   2018-03-14 14:19:04          6          .          .   14mar2018 14:19:04   21257   14        0 |
381. | 1111110000112   2018-03-14 14:20:04          6          .          .   14mar2018 14:20:04   21257   14        0 |
382. | 1111110000112   2018-03-14 14:21:04          1          .          .   14mar2018 14:21:04   21257   14        0 |
383. | 1111110000112   2018-03-14 14:22:04          1          .          .   14mar2018 14:22:04   21257   14        0 |
384. | 1111110000112   2018-03-14 14:23:04          6          .          .   14mar2018 14:23:04   21257   14        0 |
385. | 1111110000112   2018-03-14 14:24:04          1          .          .   14mar2018 14:24:04   21257   14        0 |
386. | 1111110000112   2018-03-14 14:25:04          1          .          .   14mar2018 14:25:04   21257   14        0 |
387. | 1111110000112   2018-03-14 14:26:04          1          .          .   14mar2018 14:26:04   21257   14        0 |
388. | 1111110000112   2018-03-14 14:27:04          1          .          .   14mar2018 14:27:04   21257   14        0 |
389. | 1111110000112   2018-03-14 14:28:04          1          .          .   14mar2018 14:28:04   21257   14        0 |
390. | 1111110000112   2018-03-14 14:29:04          1          .          .   14mar2018 14:29:04   21257   14        0 |
     +-----------------------------------------------------------------------------------------------------------------+

.