I have already imported the data in excel and did text to columns, the time is in its own cell. More raw data is below. Essentially I need to weed out the rows that do not have a unique identifier to the one below it. So, for example, the line/rows in blue will be deleted as will all other rows that do not have an equal unique identifier (shown in red). I just highlighted the first few, not the whole example but I believe you will get the idea.
Unfortunately the unique numbers in red start to repeat after 999 so that poses an added step as well.
The answer, I would like at least, to be .016 in the example versus a single digit just so I can understand what my averages are and the like. I only need to subtract the differences of the time cells that have matching unique id's. For example line three below from line 2. Then subtract line five from line four etc..... I have about 40K rows of data per workday and five work days to work through. Also I am leaving for the day but will check back on this post in the next few hours. Thank you in advance.
2012 02 17 11:18:59.050|081,999999999999~999999999999
2012 02 17 11:18:59.550|082,MCTO05222CZ0~999999999999
2012 02 17 11:18:59.566|082,1
2012 02 17 11:19:00.144|083,MCTO05246CK0~999999999999
2012 02 17 11:19:00.160|083,3
2012 02 17 11:19:01.379|No new data in last ten attempts
2012 02 17 11:19:02.754|No new data in last ten attempts
2012 02 17 11:19:04.160|No new data in last ten attempts
2012 02 17 11:19:05.535|084,MCTO05225CK0~999999999999
2012 02 17 11:19:05.551|084,3
2012 02 17 11:19:06.144|085,999999999999~999999999999
2012 02 17 11:19:06.754|086,MCTO05133BJ0~999999999999
2012 02 17 11:19:06.769|086,10
2012 02 17 11:19:08.051|No new data in last ten attempts
2012 02 17 11:19:09.269|087,999999999999~xxxxxxxxx300
2012 02 17 11:19:09.285|087,3
2012 02 17 11:19:10.551|No new data in last ten attempts
2012 02 17 11:19:11.879|No new data in last ten attempts
2012 02 17 11:19:13.254|No new data in last ten attempts
2012 02 17 11:19:14.145|088,MCTO05117AV0~999999999999
2012 02 17 11:19:14.160|088,10
2012 02 17 11:19:15.363|No new data in last ten attempts
2012 02 17 11:19:16.254|089,999999999999~xxxxxxxxx300
2012 02 17 11:19:16.285|089,3
2012 02 17 11:19:17.160|090,MCTO05225AR0~999999999999
2012 02 17 11:19:17.191|090,1
2012 02 17 11:19:17.863|091,MCTO05144BF0~999999999999
2012 02 17 11:19:17.942|091,10
2012 02 17 11:19:19.145|No new data in last ten attempts
2012 02 17 11:19:19.363|092,MCTO05336BX0~999999999999
2012 02 17 11:19:19.457|092,1
2012 02 17 11:19:20.645|No new data in last ten attempts
2012 02 17 11:19:20.754|093,MCTO05226BL0~999999999999
2012 02 17 11:19:20.770|093,1
2012 02 17 11:19:21.770|094,MCTO05226AM0~999999999999
2012 02 17 11:19:21.785|094,10
2012 02 17 11:19:22.864|095,999999999999~xxxxxxxxx300
2012 02 17 11:19:22.957|095,3
2012 02 17 11:19:23.395|096,999999999999~999999999999
2012 02 17 11:19:24.660|No new data in last ten attempts
2012 02 17 11:19:25.145|097,MCTO05125AH0~999999999999
2012 02 17 11:19:25.160|097,10
2012 02 17 11:19:26.254|098,MCTO05235AD0~999999999999
2012 02 17 11:19:26.270|098,1
2012 02 17 11:19:27.270|099,MCTO05234CA0~999999999999
2012 02 17 11:19:27.285|099,3