date format in csv export

Prashanth Danda (11●1) | asked Apr 25 '17, 10:54 a.m.

Hi Rob Logie,

I am reading the below page where you have provided answer to convert string into an excel time stamp.

You have given formula to convert Apr 24, 2017 5:22 AM into 24/04/2017 05:22.

I need an Excel formula to convert 2017-04-11T10:04:33.632Z into 11/04/2017 10:04

Please can you assist me with the Excel formula?

Thanks a million.

Be the first one to answer this question!