convert this export data format 2019-08-28T19:00:00Z

in tradingview if I export data, the time is in this format on the csv. 2019-08-28T19:00:00Z and the time is off by 4 hr, what can I do to make it 8/28/19 15:00.
thanks.

misread question

Another way of doing it, use this Formula;

Formula:

Please Login or Register  to view this content.

Right click on the cell, format cells as Custom - m/dd/yy hh:mm

I made an function in VBA that converts this ISO8601 date

Please Login or Register  to view this content.

This function can either be used in the worksheet to give the outcome which you need to format (same like PaulSP solution)
Or you can make te function part of any existing code you have to import this type of data

I see you do not have a excel version in your profile but if you are on a more recent version (2010 or higher) you can also use powerquery to import the CSV files.

PowerQuery will automaticly recognize the ISO8601 date format and also automaticly converts the time to your local timezone (based on pc settings)
To explain the timeformat the Z at the end represents "Zulu time" which is simular to UTC or GMT (Greenwich Mean Time), This is the standard time to which all time zones are derived from.
so in your case you are -4 hours of zulu time. and powerquery will interpret that for you and change the date

see instruction on how to use powerquery (called get and transform for excel 2013 and later version)
https://www.myexcelonline.com/blog/i...get-transform/