hi again,

Am Mon, 7 Sep 2015 11:03:40 +0200 schrieb Claus Busch:

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))

or without helper column for the time in B3:
=TIME(MID(A3,10,2),MID(A3,12,2),MID(A3,14,2))-TIME(MID(A2,10,2),MID(A2,12,2),MID(A2,14,2))
and copy down.


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