Hi,
I'm wondering how best to approach this...
The formula I have in I2 is:
=IF(RIGHT(H2,5)="00000",IF(ISERROR(MID(F2,FIND("LOCDIFF",F2)+9,FIND(":",F2,FIND("LOCDIFF",F2))-FIND("LOCDIFF",F2)-12)),H2,MID(F2,FIND("LOCDIFF",F2)+9,FIND(":",F2,FIND("LOCDIFF",F2))-FIND("LOCDIFF",F2)-12)),"")...