Forum Discussion
nathnicconnexion
Jan 16, 2024Copper Contributor
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
And i need to convert it into a different format before migration. The requested format is this: MM/dd/YYYY HH:mm
I hae not so far managed to do it... any ideas?
Thanks in advance,
Nath
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.
- nathnicconnexionCopper Contributor
Thank you very much for taking the time HansVogelaar very helpful!