Results 1 to 3 of 3

Filter/Delete for Certain Date&Time

Threaded View

  1. #1
    Registered User
    Join Date
    02-20-2009
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    92

    Filter/Delete for Certain Date&Time

    Hello,

    I have a list of dates and times. I'd like to delete everything before prior business day 4:00 pm.

    Here is an example list. Assume today is 06/09/2011. The format of the cells is custom mm/dd/yyyy h:mm. If possible, I'd like a loop that goes through and deletes any row older than 4:00 pm prior business day.

    06/09/2011 12:18
    06/09/2011 12:18
    06/08/2011 12:18
    06/09/2011 12:17
    06/09/2011 12:15
    06/09/2011 12:15

    So that would be my best case scenario. I'm open to additional suggestions as well. As always, help and input is always very much appreciated. Thank you!
    Last edited by starcraftbud; 06-09-2011 at 02:19 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1