It is difficult to generalise on just one example, but try this in D2:

=LEFT(C2,FIND(" ran",C2)-1)*1

and this in E2:

=TRIM(MID(C2,FIND("TIME",C2)+4,10))

Hope this helps.

Pete