analysis 8.5.420

wisemonk
Posts: 6
Joined: Tue May 26, 2020 2:19 am

analysis 8.5.420

Postby wisemonk » Thu May 28, 2020 1:43 am

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

wisemonk
Posts: 6
Joined: Tue May 26, 2020 2:19 am

Re: analysis 8.5.420

Postby wisemonk » Thu May 28, 2020 5:50 am

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


Return to “General support questions”

Who is online

Users browsing this forum: Google [Bot] and 28 guests