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
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

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.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,384
Messages
5,836,946
Members
430,464
Latest member
nickburrett

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