Results 1 to 11 of 11

Time overlap detection

Threaded View

  1. #1
    Registered User
    Join Date
    01-03-2020
    Location
    US
    MS-Off Ver
    2019
    Posts
    85

    Question Time overlap detection

    Hi,
    I want to detect time overlap (interference) in my dataset. I have provided a sample data file. As you see, there is Start date, End date, Start time, and End time columns which show each person's work information. There are some time overlap for each person in those columns. I want to write a VBA code for automating the detection process. Those rows which have interference with each other (for each person) should be detected and rewritten on a new sheet (the whole row should be rewritten).
    I couldn't imagine any VBA solution for this problem. I think I need to use VBA Dictionary Object, but I don't know how to implement it for this purpose.
    Please help me out. The solution would be very important in my work.
    Thanks.

    Untitled.png
    Attached Files Attached Files
    Last edited by fa2020; 11-08-2020 at 05:06 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Time overlap
    By julleke in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-08-2017, 10:30 AM
  2. Time Overlap Not working for few time range. Please help
    By pradeepn in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-21-2016, 02:43 AM
  3. [SOLVED] Time overlap
    By aanaduta in forum Excel General
    Replies: 6
    Last Post: 09-15-2015, 12:13 PM
  4. Time overlap %
    By sfire184 in forum Excel General
    Replies: 5
    Last Post: 09-09-2014, 02:23 AM
  5. [SOLVED] determine total overlap time when there are gaps in overlap (4 date ranges)
    By miriambender in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-12-2014, 11:58 PM
  6. [SOLVED] Match Function for detection of 10-90 rise time
    By bubbletea2 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-09-2013, 03:16 AM
  7. Replies: 0
    Last Post: 08-14-2013, 11:21 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