Trying to remove data rows based on Time column

[goodysgotacuda]

Hello,

I have lots of logged data, second-by-second data of a vehicle going down the road for seven days. I would like to filter some of that data for temperature graphs, things like air temperature I do not need second-by-second information on.

Within this data set, there is a date and also a time column for every temperature reading. I would like to filter the data down for every 15 minutes, so if my data started at 8:16am, I would like to have a temp reading there, then at 8:31, 8:46, etc. This would cut down the amount of data populating graphs significantly. However, I can't come up with a quick way of cutting down the data, the start and end time will vary within each data set, so I will likely need it to reference the first time stamp.

Also, each second gives me a row of data, however there are breaks in it. If the vehicle shuts off at 8pm and starts up at 8am, there is a 12hr break in time, but the data rows are right next to each other.


Any suggestions? Thanks!

 

[dermie_72]

sounds like you're looking for a slicer. It all depends on the way you have set up the data.
Slicers in Excel - Easy Excel Tutorial

 

[goodysgotacuda]

Thank you, I have worked with those before and am not sure that will get what I need to done, but I will look into that. I have ~200,000+ rows to work with.