John Thompson
Well-Known Member
I hope this is more of an Excel question than a J-Field question.
If I export a csv file that includes the field "Time Local", the csv file has a timestamp that looks something like 2016-09-20T16:52:59-06:00. If I open the csv file in Excel, I have to do a bunch of manipulation to get a single column of timestamps that Excel recognizes as timestamps. (Text to columns, separate date and time into separate columns, remove the T's and -6"00's, add the time and date columns, copy and paste as values the resulting column, then delete the time and date columns.)
Is there a simpler way to get Excel to recognize the timestamps as times?
If I export a csv file that includes the field "Time Local", the csv file has a timestamp that looks something like 2016-09-20T16:52:59-06:00. If I open the csv file in Excel, I have to do a bunch of manipulation to get a single column of timestamps that Excel recognizes as timestamps. (Text to columns, separate date and time into separate columns, remove the T's and -6"00's, add the time and date columns, copy and paste as values the resulting column, then delete the time and date columns.)
Is there a simpler way to get Excel to recognize the timestamps as times?