I am trying to figure out how to build a macro to spot missing sequence and add in a new row when found.
There should be 1440 data points in column A
The date and time formatting goes as followed
10/10/2019 7:41
10/10/2019 7:42
10/10/2019 7:43
10/10/2019 7:44
10/10/2019 7:45
10/10/2019 7:46
10/10/2019 9:52
10/10/2019 9:53
10/10/2019 9:54
10/10/2019 9:55
10/10/2019 9:56
I would like the macro to find that its missing the data between 7:47 and 9:51 and add in blank rows. The time is also in military time so the format is
10/10/2019 00:00 thru 10/10/2019 23:59
There should be 1440 data points in column A
The date and time formatting goes as followed
10/10/2019 7:41
10/10/2019 7:42
10/10/2019 7:43
10/10/2019 7:44
10/10/2019 7:45
10/10/2019 7:46
10/10/2019 9:52
10/10/2019 9:53
10/10/2019 9:54
10/10/2019 9:55
10/10/2019 9:56
I would like the macro to find that its missing the data between 7:47 and 9:51 and add in blank rows. The time is also in military time so the format is
10/10/2019 00:00 thru 10/10/2019 23:59
what I have found in the formatting of the date and time is that every entry, which is one min apart, is .0006944444 off of the next.
<strike></strike>