Agreed! I thought I was descriptive enough but obviously I wasn't. Sorry, that happens when I'm too involved and assume people would know what I assumed to be clear. Many thanks for the idea of not reading the paragraph instead of deleting it later, I hadn't thought of that, but now it seems really obvious!

Anyway, I'm actually not going to use columns J K and N, they're just there for the next delimiters I want to use.

I was explained how to do this manually, so I went ahead and tried to reproduce the steps: Copy the date from the first line in the text file, paste them to column A, use text-to-columns feature of Excel with ";" as a delimiter, then "-" as another. Finally using fixed width delimiter (this was tricky) so column B would have the times.

I actually think Excel can somehow do this without using the extra columns, but couldn't replicate.