Picking out time range

[jvddavid]

Hi,
I have the following data:
06:36:52.0000000 0000000001 OK
06:17:56.0000000 0000000001 NG
06:18:19.0000000 0000000001 NG
10:29:13.0000000 0000000001 OK
11:01:58.0000000 0000000001 NG
11:02:18.0000000 0000000001 NG
13:23:41.0000000 0000000001 OK
14:12:26.0000000 0000000001 OK
14:03:51.0000000 0000000001 OK
08:00:10.0000000 0000000001 OK
13:19:29.0000000 0000000001 OK
13:52:01.0000000 0000000001 OK
13:52:01.0000000 0000000002 OK
14:17:06.0000000 0000000001 NG
14:17:26.0000000 0000000001 NG
08:05:31.0000000 0000000001 NG
13:47:40.0000000 0000000001 NG
13:48:23.0000000 0000000001 NG
10:53:45.0000000 0000000001 OK
09:20:59.0000000 0000000001 NG

So some of those times are very close to each other menaning is just a repeat of the same data gathered. How can I weed out some of those times? for instance: 11:01:58 and 11:02:18 are only within seconds of each other. I would just like to pick out one. So it would be grabbing data for between 4 minutes lets say... instead of seconds. I am not sure if that makes sense.

Any help would be appreciated.

Thank you.

[MarvinP]

Hi david,

I had a similar problem and solved it by using the MRound() function. The idea is that you round all of your times to the closest minute or 4 minutes and delete duplicates using the Advanced Filter. Read about MRound at:

https://www.excelfunctions.net/excel...-function.html

[jvddavid]

Thank you for your response.
But will I have to switch my time to actual numbers? It doesn't seem to be working with regular times.

[MarvinP]

Hi,

I think you will need to extract the time from your data into a new column before using MRound() on it. You might also need to convert the extracted data to the correct time format.