troubleshooting Question

Time stamp differents

Avatar of nedbacan
nedbacanFlag for United States of America asked on
Microsoft ExcelMicrosoft ApplicationsMicrosoft Development
9 Comments1 Solution286 ViewsLast Modified:
Dears Experts.

I have a log file that contains thousands of lines of data.

My intention is to import it into Excel and examine the data, and perform two different checks.  

Is there a macro or can one be create to check each record date and assure each records time interval are all the same and the sequence also.  
   
Check 1:  Assure each record are 2 minutes apart or the number of seconds user assigned each record to be.
For instance,  Each record should be 2 minutes (120 seconds) aparts.
Record Number = 1,1/1/2012 2:00:00 PM
Record Number = 2,1/1/2012 2:02:00 PM
Record Number = 3,1/1/2012 2:04:00 PM
Record Number = 4,1/1/2012 2:06:00 PM

Check 2:
In the log, the column for Sensor Blinks should all be in sequential order.  
Flag each line skip. For instance the following example below, Sensor Blink 5 was skipped, so it needs to be reported.
Sensor Blinks = 1,
Sensor Blinks = 2,
Sensor Blinks = 3,
Sensor Blinks = 4,
Sensor Blinks = 6,
Sensor Blinks = 7,
TEST.txt
ASKER CERTIFIED SOLUTION
aikimark
Get vaccinated; Social distance; Wear a mask
Join our community to see this answer!
Unlock 1 Answer and 9 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 9 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros