Libre Calc import multiple lines containing time and date

[usiegel]

Hello,
i have a text file in which dates are stored like

Jan 2 2025 10:12	Jan 2 2025 16:34
Jan 3 2025 06:45	Jan 3 2025 16:01

In Libre Calc i want to do following:

• insert in Column B and C data from above
• in column A i have imply “=B$row”, i.e. “=B1”, “=B2”,… (without double quotes)
• column A has format NN, meaning dates weekday, i.e. Thu
• column B and C are formatted MMM D YYYY HH:MM
• column D is C-B, formatted HH:MM
  When i insert a single line, i.e. top one from example above, in column B and C,
  everything works correct, and in column A weekday is shown, and duration is in column D

When i insert more than one line from text file at once,
each cell starts with single quote, marking the content as text.

Is there a way to insert more than one line at a time without getting the content quoted?

[LeroyG]

I tested to paste in a spreadsheet the two lines that you shared, and they were pasted correctly (without ').
Maybe you can share a reduced source file to test copy and paste.
Also, you can test with Paste Special (Ctrl+Shift+V) and the following Text Import dialog.

[usiegel]

Hi Leroy,
many thanks for your comment. Meanwhile i dug deeper and found a solution.
Firstly, when pasting data in Libre Calc, i have to
- “Paste Special” - “Unformatted Text”, and then
i dialog select a column and from drop-down above select “Date (MDY)” and data will be treated correctly.
Made the mistake not to select the columns and select correct “Column Type”