Hello people.
Can you help with this problem I have been stuck on for quite a while now.
My data set consists of 2 columns: A - the points name (of which there is about 11)
B - date and time (DD/MM/YYYY HH:MM:SS) (should be every 15 minutes, multiples of 15: 00, 15, 30, 45)
the data set is a whole month
So, each point should have a date and time every 15 minutes, however, sometimes this does not happen. The minimum is that every point should have at least 1 reading every hour.
Is it possible to be able search the whole dataset and find which points do not have at least 1 reading every hour and if it doesn't return which point and the date and time?
Thanks guys, appreciated
example of data -
[TABLE="width: 252"]
<tbody>[TR]
[TD]Point 1[/TD]
[TD="align: right"]31/03/2014 23:45[/TD]
[/TR]
[TR]
[TD]Point 1[/TD]
[TD="align: right"]31/03/2014 23:30[/TD]
[/TR]
[TR]
[TD]Point 1[/TD]
[TD="align: right"]29/03/2014 19:15[/TD]
[/TR]
[TR]
[TD]Point 1[/TD]
[TD="align: right"]29/03/2014 19:00[/TD]
[/TR]
[TR]
[TD]Point 1[/TD]
[TD="align: right"]18/03/2014 15:30[/TD]
[/TR]
[TR]
[TD]Point 1[/TD]
[TD="align: right"]18/03/2014 15:45[/TD]
[/TR]
[TR]
[TD]Point 1[/TD]
[TD="align: right"]08/03/2014 19:30[/TD]
[/TR]
[TR]
[TD]Point 1[/TD]
[TD="align: right"]08/03/2014 19:45[/TD]
[/TR]
[TR]
[TD]Point 1[/TD]
[TD="align: right"]08/03/2014 20:00[/TD]
[/TR]
[TR]
[TD]point 2[/TD]
[TD="align: right"]09/03/2014 14:30[/TD]
[/TR]
[TR]
[TD]point 2[/TD]
[TD="align: right"]09/03/2014 14:45[/TD]
[/TR]
[TR]
[TD]point 2[/TD]
[TD="align: right"]09/03/2014 15:00[/TD]
[/TR]
[TR]
[TD]point 2[/TD]
[TD="align: right"]09/03/2014 15:15[/TD]
[/TR]
[TR]
[TD]point 2[/TD]
[TD="align: right"]01/03/2014 02:15[/TD]
[/TR]
[TR]
[TD]point 2[/TD]
[TD="align: right"]01/03/2014 02:30[/TD]
[/TR]
[TR]
[TD]point 3[/TD]
[TD="align: right"]01/03/2014 03:30[/TD]
[/TR]
[TR]
[TD]point 3[/TD]
[TD="align: right"]01/03/2014 03:45[/TD]
[/TR]
[TR]
[TD]point 3[/TD]
[TD="align: right"]01/03/2014 04:00[/TD]
[/TR]
[TR]
[TD]point 3[/TD]
[TD="align: right"]01/03/2014 04:15[/TD]
[/TR]
[TR]
[TD]point 3[/TD]
[TD="align: right"]20/03/2014 22:30[/TD]
[/TR]
[TR]
[TD]point 3[/TD]
[TD="align: right"]20/03/2014 22:45[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 175"]
<tbody>[TR]
[TD][TABLE="width: 252"]
<tbody>[TR]
[TD="width: 64"][/TD]
[TD="class: xl65, width: 188, align: right"][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
</tbody>[/TABLE]
Can you help with this problem I have been stuck on for quite a while now.
My data set consists of 2 columns: A - the points name (of which there is about 11)
B - date and time (DD/MM/YYYY HH:MM:SS) (should be every 15 minutes, multiples of 15: 00, 15, 30, 45)
the data set is a whole month
So, each point should have a date and time every 15 minutes, however, sometimes this does not happen. The minimum is that every point should have at least 1 reading every hour.
Is it possible to be able search the whole dataset and find which points do not have at least 1 reading every hour and if it doesn't return which point and the date and time?
Thanks guys, appreciated
example of data -
[TABLE="width: 252"]
<tbody>[TR]
[TD]Point 1[/TD]
[TD="align: right"]31/03/2014 23:45[/TD]
[/TR]
[TR]
[TD]Point 1[/TD]
[TD="align: right"]31/03/2014 23:30[/TD]
[/TR]
[TR]
[TD]Point 1[/TD]
[TD="align: right"]29/03/2014 19:15[/TD]
[/TR]
[TR]
[TD]Point 1[/TD]
[TD="align: right"]29/03/2014 19:00[/TD]
[/TR]
[TR]
[TD]Point 1[/TD]
[TD="align: right"]18/03/2014 15:30[/TD]
[/TR]
[TR]
[TD]Point 1[/TD]
[TD="align: right"]18/03/2014 15:45[/TD]
[/TR]
[TR]
[TD]Point 1[/TD]
[TD="align: right"]08/03/2014 19:30[/TD]
[/TR]
[TR]
[TD]Point 1[/TD]
[TD="align: right"]08/03/2014 19:45[/TD]
[/TR]
[TR]
[TD]Point 1[/TD]
[TD="align: right"]08/03/2014 20:00[/TD]
[/TR]
[TR]
[TD]point 2[/TD]
[TD="align: right"]09/03/2014 14:30[/TD]
[/TR]
[TR]
[TD]point 2[/TD]
[TD="align: right"]09/03/2014 14:45[/TD]
[/TR]
[TR]
[TD]point 2[/TD]
[TD="align: right"]09/03/2014 15:00[/TD]
[/TR]
[TR]
[TD]point 2[/TD]
[TD="align: right"]09/03/2014 15:15[/TD]
[/TR]
[TR]
[TD]point 2[/TD]
[TD="align: right"]01/03/2014 02:15[/TD]
[/TR]
[TR]
[TD]point 2[/TD]
[TD="align: right"]01/03/2014 02:30[/TD]
[/TR]
[TR]
[TD]point 3[/TD]
[TD="align: right"]01/03/2014 03:30[/TD]
[/TR]
[TR]
[TD]point 3[/TD]
[TD="align: right"]01/03/2014 03:45[/TD]
[/TR]
[TR]
[TD]point 3[/TD]
[TD="align: right"]01/03/2014 04:00[/TD]
[/TR]
[TR]
[TD]point 3[/TD]
[TD="align: right"]01/03/2014 04:15[/TD]
[/TR]
[TR]
[TD]point 3[/TD]
[TD="align: right"]20/03/2014 22:30[/TD]
[/TR]
[TR]
[TD]point 3[/TD]
[TD="align: right"]20/03/2014 22:45[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 175"]
<tbody>[TR]
[TD][TABLE="width: 252"]
<tbody>[TR]
[TD="width: 64"][/TD]
[TD="class: xl65, width: 188, align: right"][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
</tbody>[/TABLE]