Date and Time to Time Only

[#1]

Help nothing works. I want to convert a date and time field to time only

The field I'm converting always looks like this  with dates as 00/01/1900 with the time after ie

  00/01/1900 00:01:03

  00/01/1900 10:05:13

  00/01/1900 15:29:22

  00/01/1900 20:44:52

nothing seems to extract the time only any ideas

[nam]

oik iv just tested this and works using your excel.

Load your excel,

do a resident load with the below for time

time(subfield(time,'Space'  ,1)) as Time 2   

and it works fine I can send you the app if this does not work

[tresesco]

See, I tried with your attached excel and it worked.

[nam]