What I am trying to do does not seem to work with basic filtering.
I want to only keep records that have at least 45 minutes between them and filter out all others. As an example I have included a small set of data and I want to keep only the data that has <-- next to it. I hope this makes what I am looking for a little clearer. I also attached a small amount of data as well I could not figure out how to space it appropriately so I alternated bold and not bold for each column.
coy-id date time serial-date.time
14 9/20/02 2:14 37519.0930555556<--
14 9/20/02 2:24 37519.1
14 9/20/02 2:35 37519.1076388889
14 9/20/02 2:46 37519.1152777778
14 9/20/02 2:55 37519.1215277778 <--
14 9/20/02 3:05 37519.1284722222
14 9/20/02 3:15 37519.1354166667
14 9/20/02 3:25 37519.1423611111
14 9/20/02 3:36 37519.15
14 9/20/02 3:45 37519.15625 <--
14 9/20/02 3:54 37519.1625
14 9/26/02 4:13 37525.1756944444
14 9/26/02 4:24 37525.1833333333
14 9/26/02 4:34 37525.1902777778 <--
14 9/26/02 4:43 37525.1965277778
14 9/26/02 4:54 37525.2041666667
14 9/26/02 5:04 37525.2111111111 <--
14 9/26/02 5:15 37525.21875
14 9/26/02 5:25 37525.2256944444
14 9/26/02 5:33 37525.23125
14 9/26/02 5:44 37525.2388888889
14 9/26/02 5:54 37525.2458333333<--
14 10/7/02 20:20 37536.8472222222<--
14 10/7/02 20:30 37536.8541666667
14 10/7/02 20:40 37536.8611111111
14 10/7/02 20:50 37536.8680555556
14 10/7/02 21:00 37536.875
14 10/7/02 21:10 37536.8819444444 <--
14 10/7/02 21:20 37536.8888888889
14 10/7/02 21:30 37536.8958333333
14 10/7/02 21:40 37536.9027777778
14 10/7/02 21:50 37536.9097222222
Bookmarks