Thank you for kind teaching and advice.
I have a question about time recording to Excel.
For summary:
arduino uno or mega and RTC and SD card
several analogue inputs
time and analogue inputs recording to excel's cell
example) 09/27/2016 1:33 25 35 19 23
What is the problem?
Excel's colum shows always 09/27/2016 1:33.
But, there is the code for second.
If I double click the cell for time, I can read 'second' in the cell as 09/27/2016 1:33.41 AM.
As if second number is hidden..
I want to read all time number include second at the same time.
This is the code.
Please, let me know the erros in the code.
I think that the problem is the code -dataFile.print(" , "); -.
How about you?
Maybe opening an excel document based on a template with correct formatting of the colums can do the trick.
You might also be able to force excel to treat the date/time as text by putting a single tick in front of the date/time that you send; excel will hide the single tick (') if I'm not mistaken. But I hate corrupting data just for the sake of display purposes.
You can do it by preventing Excel recognising your timestamp as its own dateTime datatype by, for example, including an '_' character between the date part and the time part.
6v6gt:
You can do it by preventing Excel recognising your timestamp as its own dateTime datatype by, for example, including an '_' character between the date part and the time part.
sterretje:
Maybe opening an excel document based on a template with correct formatting of the colums can do the trick.
You might also be able to force excel to treat the date/time as text by putting a single tick in front of the date/time that you send; excel will hide the single tick (') if I'm not mistaken. But I hate corrupting data just for the sake of display purposes.
Thank you for kind advice, sterretje,
I'm a biginner, so it is difficult to make a nice and perfect code.
If you export to excel I suppose this is to do something more than displaying columns? Wouldn't it be actually better if excel was recognizing your dates correctly as dates so that you can do time graph properly for example ?
This is really an excel import challenge when reading your text file.
I would suggest to separate the day and the time into two columns rather than just one, this way excel recognizes the format properly for both and you get usable data in your cells