Thank you, Haikuo! The flagging was perfect.
However, for the 1st value of time_abve_15, it should be 07JUN2017:21:56:00 - 07JUN2017:19:39:00
For how long was it above 15, the value of time_abve_15 should be: 08JUN2017:03:14:00 - 07JUN2017:21:56:00
Sorry, if I didn't expalin it properly, but I'm still not able to get for how long is the value of dose > 15.
ID
TIME
DOSE
flag
time_abve_15
101
07JUN2017:19:39:00
14
0
.
101
07JUN2017:20:48:00
15
0
.
101
07JUN2017:21:56:00
16
1
6
101
08JUN2017:00:15:00
18
1
6
101
08JUN2017:01:12:00
20
1
6
101
08JUN2017:03:14:00
14
1
6
101
08JUN2017:06:42:00
13
0
.
101
08JUN2017:07:38:00
6
0
.
101
08JUN2017:08:06:00
7
0
.
101
08JUN2017:09:03:00
8
0
.
102
08JUN2017:10:18:00
12
0
.
102
08JUN2017:11:02:00
10
0
.
102
08JUN2017:12:55:00
11
0
.
102
08JUN2017:15:17:00
20
1
2
102
08JUN2017:16:07:00
21
1
2
102
08JUN2017:17:48:00
14
1
2
102
08JUN2017:19:21:00
14
0
.
102
08JUN2017:20:05:00
13
0
.
... View more