+ Reply to Thread
Results 1 to 3 of 3

Time overlapping

  1. 12-01-2020, 11:33 PM #1
    angelosison00
    angelosison00 is offline
    Registered User
    Join Date
    05-18-2017
    Location
    PHILIPPINES
    MS-Off Ver
    2010
    Posts
    26

    Time overlapping

    hi can anyone help to determine the time overlapping within the same member id.
    see attached sample.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 12-02-2020, 03:17 AM #2
    vba_php
    vba_php is offline
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: Time overlapping

    what is this an issue? who is using this? ideally, with a well set up sheet, this issue should not occur. is this a timesheet?
    Reply With QuoteRegister To Reply
  3. 12-02-2020, 04:52 AM #3
    Bo_Ry
    Bo_Ry is offline
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Time overlapping

    Please try at D2
    =REPT("Overlapping",COUNTIFS($A$2:$A$11,A2,$B$2:$B$11,"<"&C2,$C$2:$C$11,">"&B2)>1)
    Attached Files Attached Files
    Linkedin/Bo-Rydobon
    Youtube.com/XcWizard
    Facebook.com/XcWizard
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Finding overlapping time instances
    By shauncrom in forum Excel General
    Replies: 6
    Last Post: 05-28-2020, 11:43 AM
  2. [SOLVED] Overlapping time calculation
    By klesqus in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-18-2018, 06:52 AM
  3. [SOLVED] Function to understand blank cell for no digits (time),#value# , & time overlapping
    By Karnik in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-07-2017, 05:27 PM
  4. Overlapping Time (Schedules)
    By leysanity in forum Excel General
    Replies: 9
    Last Post: 12-02-2016, 10:40 PM
  5. [SOLVED] Overlapping time within one column
    By heneli627 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 05-07-2015, 05:47 AM
  6. Counting Overlapping Time & Non-Overlapping Time
    By I_need_help1 in forum Excel General
    Replies: 4
    Last Post: 02-08-2011, 02:36 PM
  7. Overlapping Time Formula
    By misterzr in forum Excel General
    Replies: 4
    Last Post: 01-21-2011, 05:55 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1