Removing time stamps that are less then "x" seconds after the previous time stamp

[Navara32]

G'day everyone,

I have come across a problem that I am struggling to find a solution for and hoping someone can help me out.

Basically we use a device to take a time stamp on an up ramp of a signal. Occasionally however the device triggers again on the down ramp, 30 seconds later.
We do not trigger the device again for at least another 30 seconds, so im trying to find a formula that can help me identify and remove any row where its timestamp is less then 35 seconds after the previous time stamp above it.

Now i think that bit is fairly simple, however, the time stamps are in the format: hh:mm:ss.000000
Once i go to 6 decimal places of a second, excel seems to get very tricky and i cant currently have the data as a time format, i have to have it as a text format.


The example workbook shows the data after I have ran a macro to separate the time stamps into the individual parts. (Hours, Minutes, Seconds, etc.) Then also how i have joined these back together to be used later.
As you can see, row 5 and 6 are just 30 seconds apart and therefor i would delete row 6. Same with 13 and 14 where i would delete row 14.


We are trying to fix the problem in the first place but for the time been i have alot of data that i need to manually sort through to find the incorrect timestamps and delete them which is taking a long time.

Would appreciate any help with the issue.

Thanks!


Jim.