Seeking Excel Advice: Identifying Unpaired Transactions with Matching Timestamps?

I am using excel and I want to do something like checking for Margin Repayment that doesn't have transaction sold pair with it in the exact same time. After it check, it can either tell me the line or highlight it for me. Like the picture I manually uploaded. I tried to ask GPT4 but I keep pasting the formula in it doesnt work.
Image 1: gyazo com/2eca5cce5dc9bd2e84947be0edd8e672

Alternatively I also dont mind if there is a formula to highlight the exact same time in different colours so its easier to see for me like this. See how if its the exact time by minute, it is grouped together and coloured in.
Image 2: gyazo com/e5a9d2067c4f87ec52bed51a32a02ce2

Would help a lot if I can pay someone to do it

Upload the sample workbook(s) here. Most people won't follow links. There's a lot of nasty stuff out there. Not that I"m paranoid.


Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.

Depending which way you want to go, use one of these:

Formula:

Please Login or Register  to view this content.

Formula:

Please Login or Register  to view this content.

Note that you are not displaying seconds in the date/time column. They are different. Hence the reason for using TEXT.