Converting MT5 Date and Time

[SOdie]

I trade the markets using a platform called MT5. They export a date time format of "2018.01.02 08:19:59". Does anyone know how I can convert this to Excel format?

 

[jtakw]

Hi,

With formula:

Book3.xlsx
	A	B	C	D
1	2018.01.02 14:19:59		01/02/18 14:19:59	<Format cell mm/dd/yy h:mm:ss
Sheet974

Cell Formulas
Range	Formula
C1	C1	=SUBSTITUTE(A1,".","-")+0

 

[SOdie]

Hi,

With formula:

Book3.xlsx
	A	B	C	D
1	2018.01.02 14:19:59		01/02/18 14:19:59	<Format cell mm/dd/yy h:mm:ss
Sheet974

Cell Formulas
Range	Formula
C1	C1	=SUBSTITUTE(A1,".","-")+0

Thank you so much! This is outstanding.

 

[jtakw]

You're welcome, thanks for the feedback.