Results 1 to 7 of 7

Display start time and end time overlapping

Threaded View

  1. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 365 version 2501
    Posts
    19,043

    Re: Display start time and end time overlapping

    Not very elegant, perhaps someone will improve upon it.
    For columns D:E =IF(OR($A6>=$B$2,$B6<=$A$2),"no overlap",IF(D$5="Start overlap time",MAX(A$2,A6),MIN(A$2,A6)))
    For column J: =IF(AND(G6<H6,G6>=H$2,H6<=G$2),"no overlap",IF(OR(G6>G$2,G6<H$2),G6,IF(OR(H6>G$2,H6<H$2,AND(G6<=G$2,H6>=H$2)),G$2)))
    For column K: =IF(J6="no overlap","no overlap",IF(OR(H6>G$2,H6<H$2),H6,IF(AND(G6<=G$2,H6>=H$2),H$2,H$2)))
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Overlapping Time Intervals - Formula to Show Start Overlaps
    By ARec3 in forum Excel General
    Replies: 3
    Last Post: 10-16-2017, 09:13 AM
  2. Autofilter to display results between start time and stop time
    By jpullen88 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-22-2016, 03:35 AM
  3. Replies: 0
    Last Post: 03-04-2016, 06:38 PM
  4. Replies: 4
    Last Post: 03-02-2016, 02:46 AM
  5. Sum overlapping start end time intervals
    By Jack-of-Trades in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 10-15-2014, 12:56 PM
  6. Replies: 3
    Last Post: 03-27-2012, 01:07 PM
  7. display end time automatically upon entering start time and time usage
    By stoey in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-19-2008, 06:16 PM

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