string to time(hh:mm)

[#1]

Hi-I have a string field which looks like 20120927-00:00:01.Can you please let me know how can I extract only HH:MM.Thanks-Pooja

[Gysbert_Wassenaar · Accepted solution]

I think this should work: time(time#('20120927-00:00:01','yyyyMMdd-hh:mm:ss'),'hh:mm')

[#3]

Thanks a lot for your quick response.