Forum Discussion
Changing date/time to specific custom format
Hi al, I hope you can help. I have a big data file where i have to change date/time cells showing information in this format: 2021-09-04 00:38:23 CEST OR this format 2023-12-31 09:23:45 CET...
If you don't need to convert the time zone:
The value highlighted in yellow is in cell D3 as far as I can tell. In another cell, enter the formula
=DATE(LEFT(D3,4),MID(D3,6,2),MID(D3,9,2))+TIMEVALUE(MID(D3,12,5))
Format the cell with the formula as mm/dd/yyyy hh:mm
Fill down and to the right.
Thank you very much for taking the time HansVogelaar very helpful!