jmicrobe / odin

Repo for documentation related to the Optical Density Instrument at the Stahl lab
MIT License
1 stars 2 forks source link

Prepended a new column to the SD Card logging that gives the date and… #32

Closed jsebrof closed 6 years ago

jsebrof commented 6 years ago

… time stored in the Real-Time Clock when each logging line is written.

jmicrobe commented 6 years ago
screen shot 2018-10-10 at 3 07 11 pm

Tested and it works great. This is very helpful, thanks!

jsebrof commented 6 years ago

@jmicrobe From your screenshot, it looks like your spreadsheet program is reformatting the date, and truncating the seconds value that should be at the end. This commonly happens in Excel I know with datetime fields. If you look at the raw CSV file, this datetime column should have values formatted like the following: 2018/9/31 17:41:12 (This is for September 31st, 2018 at 5:41pm and 12 seconds) Just in case you find the seconds field helpful.

jmicrobe commented 6 years ago

Yes that's right, excel hid some of the info. Looking at the raw data it shows: 2018/10/10 14:49:56