Convert TimesStamp to date

[Judicael]

Hello,

How can I convert data "5/25/2017 1:01:05 PM" to 25/5/2017 13:05:05" ?

Thanks for helps.

Regards,

[Judicael · Accepted solution]

=DATE(DATE#(TimeStamp,'M/DD/YYYY hh:mm:ss TT'),'DD/MM/YYYY hh:mm:ss')