how to check the missing log

only_lonely

Board Regular
Joined
Aug 24, 2006
Messages
80
got a list which contain the date and time for my windows logging.
each interval time is approx 3mins.
after i manually calculate,found that in 24hrs ,certain time, the windows failed to log.
how to find the missing log?
it got thounsands over logs,which i can't check it one by one.
can i just with a formula and find the log?

example of my log:
17/08/2007 05:13:55
17/08/2007 05:16:34
17/08/2007 05:19:14
17/08/2007 05:21:54
17/08/2007 05:24:34
17/08/2007 05:27:14
17/08/2007 05:29:55
17/08/2007 05:32:34
17/08/2007 05:35:14
17/08/2007 05:37:54
17/08/2007 05:40:34
17/08/2007 05:43:14
17/08/2007 05:45:54
17/08/2007 05:48:34
17/08/2007 05:51:14
17/08/2007 05:53:54
17/08/2007 05:56:34
17/08/2007 05:59:14
 

Some videos you may like

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
Hi

Assuming each of those Date/Times are in an individual cell, maybe you could use something like the following in an adjacent column (returns False if not a consecutive log time):

Excel Workbook
AB
117/08/2007 05:130
217/08/2007 05:16TRUE
317/08/2007 05:19TRUE
417/08/2007 05:21TRUE
517/08/2007 05:24TRUE
617/08/2007 05:27TRUE
717/08/2007 05:29TRUE
817/08/2007 05:32TRUE
917/08/2007 05:35TRUE
1017/08/2007 05:37TRUE
1117/08/2007 05:43FALSE
1217/08/2007 05:43TRUE
1317/08/2007 05:45TRUE
1417/08/2007 05:48TRUE
1517/08/2007 05:51TRUE
1617/08/2007 05:53TRUE
1717/08/2007 05:56TRUE
1817/08/2007 05:59TRUE
Sheet1


Formula in B2 is copied down as far as required.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,336
Messages
5,601,023
Members
414,421
Latest member
tonybear1994

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top