Column E is easy enough:

=TEXT(B2,"dd/mmm/yy")&" "&TEXT(--LEFT(C2,FIND(" ",C2)-1),"hh:mm:ss")

But do you need to do further manipulations with this date/time?

but, D....