Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
How can I convert data "5/25/2017 1:01:05 PM" to 25/5/2017 13:05:05" ?
Thanks for helps.
Regards,
=DATE(DATE#(TimeStamp,'M/DD/YYYY hh:mm:ss TT'),'DD/MM/YYYY hh:mm:ss')
=DATE(DATE#(TimeStamp,'M/DD/YYYY hh:mm:ss TT'),'DD/MM/YYYY hh:mm:ss')