Hi Terry,

Am Mon, 7 Sep 2015 10:59:48 +0200 schrieb Claus Busch:

in B2 try:
=TIME(MID(A2,FIND("-",A2)+1,2),MID(A2,FIND("-",A2)+3,2),MID(A2,FIND("-",A2)+5,2))

so the part in front of the hyphen is a date and has always 8 digits you
can use in B2:
=TIME(MID(A2,10,2),MID(A2,12,2),MID(A2,14,2))


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional