I'm collecting data into a CSV file. I have timestamp followed by my data. The issue is the timestamp. [image] 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 …

Steve-Mcl 4 January 2021 21:12 4

1 Like

Topic		Replies	Views
How to convert time format in this node General function-node	7	385	3 May 2022
Node-Red CSV datatype General	7	456	24 March 2021
Storing timestamp General	3	460	30 July 2021
Date formatting Dashboard	15	2122	17 December 2020
Anyone one convert timestamp (epoc) to formatted time string in a single change node? General	4	1083	7 January 2021

Copyright OpenJS Foundation and Node-RED contributors. All rights reserved. The OpenJS Foundation has registered trademarks and uses trademarks. For a list of trademarks of the OpenJS Foundation, please see our Trademark Policy and Trademark List. Trademarks and logos not indicated on the list of OpenJS Foundation trademarks are trademarks™ or registered® trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.

Converting timestamp in excel

Related topics