Forum Discussion

nathnicconnexion's avatar
nathnicconnexion
Copper Contributor
Jan 16, 2024

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

 

  • nathnicconnexion 

    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.

     

Resources