Hi again,

Am Thu, 22 Sep 2016 08:58:50 +0200 schrieb Claus Busch:

try:
=TIME(MID(A1,FIND("#",SUBSTITUTE(A1," ","#",2))+1,2),MID(A1,FIND("#",SUBSTITUTE(A1," ","#",2))+3,2),)

or:
=TIMEVALUE(TEXT(MID(A1,FIND("#",SUBSTITUTE(A1," ","#",2))+1,4),"00"":""00"))


Regards
Claus B.
--
Windows10
Office 2016