Page 1 of 1

analysis 8.5.420

Posted: Thu May 28, 2020 1:43 am
by wisemonk
Hi there,

I am wondering if there is a solution to get the actual time from the DL1 instead of the time in seconds converting to hours for example time like 11:30 am or 1:00 pm

Re: analysis 8.5.420

Posted: Thu May 28, 2020 5:50 am
by wisemonk
So i figured out if you export it out as data to excel at 1 instead of standard 0.01 other wise file will be to large and convert the GPS time (s) in time convert, converts to UTC then convert into your local time, can crate a new column in excel and use example G7+TIME(0,0,1) to add 1 second on to the convert time into the length of the data ( this doesn't count in for the leap year so the time can vary a few minutes abit depending on how much data you have ) but at least will give you a better idea on time
Hi there,

I am wondering if there is a solution to get the actual time from the DL1 instead of the time in seconds converting to hours for example time like 11:30 am or 1:00 pm