I'm collecting data into a CSV file. I have timestamp followed by my data. The issue is the timestamp.
The code works, and I'm logging the timestamp and data. But when I go to open in excel, I get the above.
Column A is the timestamp logged by node red. F is the timestamp divided by 1000 (I thought that since node red logged in milliseconds, I need to divide by 1000 to get seconds.). G is the result of F converted to format time/date. But if I enter column A or F into https://www.epochconverter.com/ it works.