+ Reply to Thread
Results 1 to 2 of 2

Filter date and time to call 24 hours of activity in overlapping dates

  1. #1
    Registered User
    Join Date
    10-10-2014
    Location
    Karachi, Pakistan
    MS-Off Ver
    2007
    Posts
    1

    Filter date and time to call 24 hours of activity in overlapping dates

    Hi
    I am new to this forum.
    I have been maintaining a manufacturing database recording time in, time out, efficiency etc

    01/10/2014 8:00 am 01/10/2014 9:30 pm
    01/10/2014 7:30 pm 01/10/2014 10:30 pm
    01/10/2014 6:00 pm 02/10/2014 8:00 am
    02/10/2014 8:30 am 02/10/2014 3:00 pm
    02/10/2014 6:00 am 02/10/2014 8:00 am

    All separate columns, I need to filter out a required 24 hours activity through filters.

    My day starts Monday 8:00 am and ends Tuesday 8:00 am.
    My required result is

    01/10/2014 8:00 am 01/10/2014 9:30 pm
    01/10/2014 7:30 pm 01/10/2014 10:30 pm
    01/10/2014 6:00 pm 02/10/2014 8:00 am
    02/10/2014 6:00 am 02/10/2014 8:00 am

    Would appreciate help here.

  2. #2
    Forum Expert
    Join Date
    09-11-2014
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    1,907

    Re: Filter date and time to call 24 hours of activity in overlapping dates

    You're not giving much information here regarding what information needs to be filtered. Maybe post a sample workbook?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Activity Time Tracker to capture activity selected from dropdown list
    By dillibabu in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-24-2013, 01:10 PM
  2. Identify and count overlapping date/time entries on a call log
    By Andrew989 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-23-2012, 12:24 PM
  3. Replies: 1
    Last Post: 05-12-2012, 06:34 AM
  4. Date and Time Stamp for Last Activity in Range
    By XLevel in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-19-2011, 07:34 AM
  5. Replies: 0
    Last Post: 09-03-2010, 05:36 AM

Tags for this Thread

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