#1
|
|||
|
|||
Date And Time Overlap Equation
Hi All,
See attached. Time overlapping happening at 3 highlighted cases. Is there any option/equation to identify these overlapping in Excel? Please advise. Thank You, Sunil Thomas |
#3
|
|||
|
|||
Thank You.
|
#4
|
|||
|
|||
Reopening this query for some other options...
|
#5
|
||||
|
||||
I'm guessing this is because your version of Excel doesn't support TEXTJOIN?
In the attached is a one-line user-defined function called txtjn which will do for your purposes, along with a tweak to the previous formula, which, like the previous one, needs to be array-entered (using Ctrl+Shift+Enter, not just Enter). See attached, cell E2 and below. |
Tags |
overlapping time and date, time overlap |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Using equation editor for the first time | teacherguy | Word | 3 | 10-06-2017 05:13 PM |
OneNote on Android phone View Tags? Enter Date, Time, Date & Time | DrTwinkyEsq | OneNote | 0 | 03-27-2017 07:54 PM |
date & time of last time a recent file was used | pgeorgilas | Word | 1 | 10-31-2014 08:59 AM |
Count the common time period (month) between two date period of time | Barni | Excel | 6 | 08-15-2014 07:52 AM |
Why copying a paragraph to an equation ends without equation format??? | Jamal NUMAN | Word | 2 | 04-24-2011 06:18 AM |