<br>=IFERROR(TEXT(TIMEVALUE(IFERROR(MID(E2, FIND(" ", E2)+1, 8),E2)),"HH:MM:SS"),"")<br>