https://bugs.documentfoundation.org/show_bug.cgi?id=151668
--- Comment #3 from Pierre Fortin <p...@pfortin.com> --- Hmm... since there is no option for TIME(HMS), the import dialog led me to believe there was no way to specify times. Based on your response, I see that selecting just the times (no date part), and choosing DATE(DMY) imports the time in a usable form. Not very intuitive... Then the Format>Cells... *does* have Time, 13:37:46 which reinforced my understanding of what was needed... The UI makes assumptions I interpreted differently... :/ Maybe the import dialog should read: [Date (DMY)] [Time (HMS)] -- You are receiving this mail because: You are the assignee for the bug.