Identify Gaps in Time Periods (non-sequential)

		Microsoft Office Forums > Microsoft Excel > Excel
Identify Gaps in Time Periods (non-sequential)

FAQ

Thread Tools

Display Modes

01-26-2022, 10:24 AM

tdeogburn

Windows 10 Identify Gaps in Time Periods (non-sequential)

Office 2016

Novice

Join Date: Jan 2022

Posts: 5

Identify Gaps in Time Periods (non-sequential)

I have a set of data that is a list of time periods. Some of these time periods overlap, and they are not sequential (one does not necessarily precede the next). I need to identify if there are any gaps in time greater than 6 months.

Is there a quick way to identify if there is a gap? Here is an example of the time periods I am dealing with:

06/2019-Present
09/2011-10/2020
03/1998-04/2002
03/1998-02/2012

Tags

gaps in time, non-sequential, start and end dates

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Adding sequential number to labels beside non sequential data	Millwood	Mail Merge	3	08-24-2020 08:55 PM
Finding gaps in a programme	Peasy	Project	12	11-20-2014 03:31 PM
Close the gaps with Bar Graphs	Alaska1	Excel	0	05-17-2013 11:55 AM
Auto Forward Emails - Specific Time Periods Only	Dav	Outlook	0	06-22-2011 12:03 PM
Identify "Propose New Time" meeting responses in VBA, and how to response with them	frilian	Outlook	0	09-02-2010 07:48 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:26 PM.