View Single Post
 
Old 01-04-2016, 03:18 PM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Quote:
Originally Posted by DPD16 View Post
Yes the time is a critical component and is used as a basis for further analysis.
Still seems to me there is no benefit to separating them other than that's how they come from the logger, but that's just me.

Quote:
the data is collected from a data logger. I had a formula (that I lost hence the request) that I could select the data set then apply a filter as I recall on a helper column to filter out "not equal to" but I don't remember how to write the helper form to separate the minutes

thank you for your response
So long as there is only one date in the data, that can be done, but you risk grabbing data from other dates, which may be wholly unrelated, if there is more than one date.

At any rate, forget about the combined Date/Time then and just apply a filter and use the Between filter under Number Filters. If you just want from 1:27 to 1:29, enter those numbers and you're good to go.
Reply With Quote