Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-06-2020, 12:28 AM
suniltko suniltko is offline Date And Time Overlap Equation Windows 7 64bit Date And Time Overlap Equation Office 2010
Novice
Date And Time Overlap Equation
 
Join Date: Mar 2017
Location: Bangalore, India
Posts: 12
suniltko is on a distinguished road
Date And Time Overlap Equation
Default 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
Attached Files
File Type: xlsx Date&Time Overlap.xlsx (10.7 KB, 7 views)
Reply With Quote
  #2  
Old 02-07-2020, 12:21 PM
p45cal p45cal is offline Date And Time Overlap Equation Windows 10 Date And Time Overlap Equation Office 2019
Expert
 
Join Date: Apr 2014
Posts: 359
p45cal has a spectacular aura aboutp45cal has a spectacular aura aboutp45cal has a spectacular aura about
Default

See attached:
Picture
Attached Files
File Type: xlsx msofficeforums44350Date&Time Overlap.xlsx (12.7 KB, 4 views)
Reply With Quote
  #3  
Old 02-10-2020, 01:20 AM
suniltko suniltko is offline Date And Time Overlap Equation Windows 10 Date And Time Overlap Equation Office 2010
Novice
Date And Time Overlap Equation
 
Join Date: Mar 2017
Location: Bangalore, India
Posts: 12
suniltko is on a distinguished road
Date And Time Overlap Equation
Default

Thank You.
Reply With Quote
  #4  
Old 02-14-2020, 02:54 AM
suniltko suniltko is offline Date And Time Overlap Equation Windows 10 Date And Time Overlap Equation Office 2010
Novice
Date And Time Overlap Equation
 
Join Date: Mar 2017
Location: Bangalore, India
Posts: 12
suniltko is on a distinguished road
Date And Time Overlap Equation
Default

Reopening this query for some other options...
Reply With Quote
  #5  
Old 02-14-2020, 08:40 AM
p45cal p45cal is offline Date And Time Overlap Equation Windows 10 Date And Time Overlap Equation Office 2019
Expert
 
Join Date: Apr 2014
Posts: 359
p45cal has a spectacular aura aboutp45cal has a spectacular aura aboutp45cal has a spectacular aura about
Default

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.
Attached Files
File Type: xlsm msofficeforums44350Date&Time Overlap_v2 for 2010.xlsm (19.0 KB, 1 views)
Reply With Quote
Reply

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 And Time Overlap Equation 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
Date And Time Overlap Equation Why copying a paragraph to an equation ends without equation format??? Jamal NUMAN Word 2 04-24-2011 06:18 AM


All times are GMT -7. The time now is 03:58 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft