Hi,
There are 2 ways of doing this. The first assumes that B2 contains the date & time as text
=TRIM(MID(B1,SEARCH(" ",B1),80))
The second assumes that B1 is in the Date / Time format
=B1-TRUNC(B1,0)
For option 2 you will need to set the cell format to Time. Be aware that you will still have a date value before the time ( ie the cell will read 00000.467 which XL thinks is 00-Jan-00 11:12 )