Google Sheet wrong date and time format for Timeline Graph

I import Tasker data source into a Google Sheet, but Timeline Graph does not work.

The format of the Date and Time is not understood.

The format of my data source is dd-MM-YYYY HH.mm For example: 16-10-2020 00.40

But Google Sheet understands only dd/MM/YYYY HH:mm:ss 16/10/2020 00:35:00

See here (On the second picture, I modified the date to be 16/10/2020 00:35:00, and applied Date and Time format, so it display 16-10-2020 00.35, which serves no purpose other than confusing you)

I've tried to change the format of the date, but the only thing it does is: Convert an already existing 16/10/2020 00:35:00 format To 16-10-2020 00.40

I want the opposite.

I'm tired and kind of angry at Google Devs. I'm been searching for hours, and I find it crazy Google Sheet cannot understand this simple format.

Please any idea?

Thank you

Please use the following formula to convert your values to dates

=ARRAYFORMULA(IF(A2:A5="",,--REGEXREPLACE(REGEXREPLACE(A2:A5,"-","/"),".",":")))

Depending on your locale you may have to change , to ;

=ARRAYFORMULA(IF(A2:A5="";;--REGEXREPLACE(REGEXREPLACE(A2:A5;"-";"/");"\.";":")))

Functions used:

• ArrayFormula
• REGEXREPLACE