Convert text MM/DD/YYYY HH:MM:SS to date-time YYYY-MM-DD HH:MM

[amaloney]

How do I convert text MM/DD/YYYY HH:MM:SS to date-time YYYY-MM-DD HH:MM in Calc

[anon73440385]

Hello,

if it is really text, then

• Select cells containing the text (or the column)
• Data -> Text to Columns...
• Select dropdown in Fields Column type: Date (MDY) (to activate click the heading which by default is named Standard)
• Click OK
• Format Cells -> Tab: Numbers and enter YYYY-MM-DD HH:MM in Format Code
• Click OK

Hope that helps.

If the answer is correct or helped you to solve your problem, please click the check mark () next to the answer.

[amaloney]

Great!! Thank you! It works.
In your third step I was choosing Date (YMD) and getting nowhere.

So, here’s what I do:

1. Open the csv document.in LibreOffice. This opens a Text Import window in LibreOffice.
2. Under Fields - click on Standard for the appropriate column.
3. Then select Column type Date (MDY) - [not YMD as I was doing before]
4. Click OK
5. The document opens in LibreOffice.
6. Select the column or cells.
7. Go to the Format Cells → Tab: Numbers and enter YYYY-MM-DD HH:MM in Format Code
8. Click OK