Track missed message with timestamp

You wouldn't know when a message has been answered as not all inbound messages require a response.

The reader is expected to always go into the oldest incoming message first which then timestamps it.  What I'm trying to ascertain from this exercise is for each message, who isn't dealing with it, the job id of the message they dealt with instead and the count of missed oppertunities for that message.

I have amended my sample data to show how outbound responses are captured but like I say, for the purpose of this I'm only interested in outbound messages where the oldest message isn't being read first.  Please also note that for any outbound messages we don't capture the read date/time of when our external supplier reads the response from their side.

Expected output:

I have also included a sample in Excel format if this helps.

https://file.io/Aw3SXLSVOaae