Function, formula or Macro help

[wwolf]

I work for a small agency that uses an RFID scanner to read rounds completed and exports the report to excel. I am trying to find a way to indicate (highlight, or message makes no matter) if the timer after scanning point A thru Z is greater then say 25mins. Sample excel report attached. So in short, I am looking for a way to denote if more then 25mins has passes since scanning the point. So if PointA timer is greater then the next entry time for PointA time then (highlight). Also of note is that the Points may not always be in the same order.

[JohnTopley]

In G13

=IF($A13-LOOKUP(2,1/($D$3:$D12=$D13),$A$3:$A12)>=25/1440,"Y","")

copy down

[wwolf]

Thank you kindly.

[AliGW]

Pleae review the forum rules on thread titles before asking another question here. Generic titles are not sufficient. Thanks.