filter to remove cells that are created by same user within 5 minutes

[Melissa Ryden]

I have a spreadsheet that show all views of knowledge articles by who viewed them, and what time they viewed the article. I would like to create a filter that basically says if "user" view time is within 5 minutes of other viewtime, eliminate the row, or highlight the row? My timestamp column is in the format 04/02/2020 8:56:29 AM.

so for example if the user field has Donald Duck viewing article How to reset password, and viewed it at 04/02/2020 8:56:29 AM and 04/02/2020 8:58:31 AM, I would like to highlight the rows that match that criteria. How could I write a filter?

2020-04-02 08:56:29​

 

[Logit]

Using the Worksheet_Change event in the worksheet module level, you could check for cell change on the sheet.
When the cell change is recognized, compare that current time with the time the user last changed a cell.