Date And Time Overlap Equation

suniltko · #1 02-06-2020, 12:28 AM

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

p45cal · #2 02-07-2020, 12:21 PM

See attached:
Picture

suniltko · #3 02-10-2020, 01:20 AM

Thank You.

suniltko · #4 02-14-2020, 02:54 AM

Reopening this query for some other options...

p45cal · #5 02-14-2020, 08:40 AM

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.

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