Make time intervals in dataset
How can one get time intervals of say like 10 mins or 15 mins from our dataset that contains date-time of the entire day in the format dd/mm/yy h:m
e.g 1/04/2019 7.02
1/04/2019 7.12
1/04/2019 7.23
1/04/2019 7.18
1/04/2019 7.36
1/04/2019 7.43
1/04/2019 7.29
1/04/2019 7.56
.
.
.
.
.
.
.
So on.......
I want to divide this datasets in intervals of 15 mins like 7.00-7.15, 7.15-7.30, 7.30-7.45, 7.45-8.00
Thanks
e.g 1/04/2019 7.02
1/04/2019 7.12
1/04/2019 7.23
1/04/2019 7.18
1/04/2019 7.36
1/04/2019 7.43
1/04/2019 7.29
1/04/2019 7.56
.
.
.
.
.
.
.
So on.......
I want to divide this datasets in intervals of 15 mins like 7.00-7.15, 7.15-7.30, 7.30-7.45, 7.45-8.00
Thanks
0
Answers
I would :
9.6 has an operator called Equalize Timestamps (or so?) which does this for you.
Best,
Martin
Dortmund, Germany
I am still not able to do that there is an error as shown in the image below I am also attaching the datasets below hope it helps.
what is the question on the error message? it is very specific? I recommend to sort before Equalize Time Stamps.
Best,
Martin
Dortmund, Germany