Hello!
I've built a data logger for taking thermal measurements in 10 second intervals and my program records the time of day with each measurement. What I am trying to do is convert my time column into a duration column. While there are plenty of ways to workaround this, like putting intervals of 10 in a column and flash filling the rest, I would like to understand if there is a good way to convert the actual time stamps.
My original plan was to subtract the first time stamp from all the time stamps which should leave me with a duration but I'm having difficulty subtracting one time from another.
yields #VALUE! in that cell.Please Login or Register to view this content.
^^ Here I have used the actual cell values instead of the references.
Attached is a sample of my data.
Thanks!
Bookmarks