Extract Time in 24H format from Date and time.

[snb]

or

=MID("ABCA",MATCH(TIMEVALUE(MID(A2,15,12))*48,{0,9 ,25,41,48},1),1)