<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_RESOLVED bz_closed" title="RESOLVED WORKSFORME - CSV Import doesn't interpret Timestamp, formulas won't calculate." href="https://bugs.documentfoundation.org/show_bug.cgi?id=112108#c7">Comment # 7</a> on <a class="bz_bug_link bz_status_RESOLVED bz_closed" title="RESOLVED WORKSFORME - CSV Import doesn't interpret Timestamp, formulas won't calculate." href="https://bugs.documentfoundation.org/show_bug.cgi?id=112108">bug 112108</a> from <a class="email" href="mailto:jbfaure@libreoffice.org" title="Jean-Baptiste Faure <jbfaure@libreoffice.org>"> Jean-Baptiste Faure</a> <pre>(In reply to m.a.riosv from <a href="show_bug.cgi?id=112108#c6">comment #6</a>) > Sorry @Jean but if I'm not wrong the PM it's not accepted and hours are > imported without take care of it. Oops, my mistake. You are right if we choose Date (MDY) for the first column, but it works as expected if we choose "US English". Once imported you can change the date format to 24 hours time cycle with "MM:DD:YYYY HH:MM:SS" format code (choose "12/31/1999 13:37:46" in the list). Then you get 08/11/2017 13:55:02 in A2. Best regards. JBF</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>