how to check the missing log

[only_lonely]

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

 

[Richard Schollar]

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
	A	B
1	17/08/2007 05:13	0
2	17/08/2007 05:16	TRUE
3	17/08/2007 05:19	TRUE
4	17/08/2007 05:21	TRUE
5	17/08/2007 05:24	TRUE
6	17/08/2007 05:27	TRUE
7	17/08/2007 05:29	TRUE
8	17/08/2007 05:32	TRUE
9	17/08/2007 05:35	TRUE
10	17/08/2007 05:37	TRUE
11	17/08/2007 05:43	FALSE
12	17/08/2007 05:43	TRUE
13	17/08/2007 05:45	TRUE
14	17/08/2007 05:48	TRUE
15	17/08/2007 05:51	TRUE
16	17/08/2007 05:53	TRUE
17	17/08/2007 05:56	TRUE
18	17/08/2007 05:59	TRUE
Sheet1

Formula in B2 is copied down as far as required.

 

[only_lonely]

thanks...it really help me to save alots of time..