Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 01-04-2016, 03:18 PM
gebobs gebobs is offline filtering a list based clock time Windows 7 64bit filtering a list based clock time 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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
filtering a list based clock time VBA: Replacement of words based on a list roderh Excel Programming 2 09-06-2015 08:54 PM
Automatically Delete Slides based on current time Pacman52 PowerPoint 2 07-16-2015 05:30 AM
filtering a list based clock time Vba macro code for grouping the data based on 2 hours time dharani suresh Excel Programming 5 04-29-2014 03:25 AM
Looking for an add-in or a way to send automatic replies based off a list brady Outlook 0 04-19-2013 01:21 PM
filtering a list based clock time field value based on time of day akraw Word 3 03-26-2011 08:29 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:03 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft