It's all about the answers!

Ask a question

date format in csv export

Prashanth Danda (112) | 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!

Register or to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.