Changing Time Format and Using Concat to add a letter into the Date?

[Marengah]

Hello Everyone!

I hope everyone is having a great start to the week! I am having an issue formatting a time punch into a different format.

The format requested is for the date to be in this format "2024-07-13T16:30:10". Essentially, I need a T between the day and the time, and the AM/PM portion dropped. This time being in 24hr format would be ideal.

Right now, my data is outputting the date as this 2024-07-13 4:30 PM.

Any input would be greatly appreciated!

Thank you!

 

[Cubist]

Try format the cell as yyyy-mm-dd"T"h:mm:ss