Quote:
Originally Posted by DPD16
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.
01-04-2016, 03:18 PM
Similar Threads
VBA: Replacement of words based on a list
Windows 7 64bit 
Office 2010 64bit
Threaded Mode