GPS V4 Expander - how do you get UTC format when you load the data into Excel? - RC Groups
Thread Tools
Jul 12, 2010, 01:17 PM
Registered User

GPS V4 Expander - how do you get UTC format when you load the data into Excel?

Anybody know why the GPS V4 Expander UTC timestamp is programmed to convert to milliseconds when you upload the data into Microsoft Excel? This is really strange, are they basing the time on milliseconds since midnight? Is there a way to keep the time in UTC in Excel?
Sign up now
to remove ads between posts
Jul 12, 2010, 08:55 PM
billpa's Avatar
Hi Mikey, it's converted to milliseconds to correspond more closely with the logged time field. Yes, it starts from midnight. But, notice that it is also saved in HH:MM:SS.SSS format under the GPSUTC-ASCII column.
Jul 13, 2010, 12:12 PM
Registered User
Thank you Bill. I failed to notice that the local time was in the date column! I didn't see a GPSUTC-ASCII column though.


Thread Tools

Similar Threads
Category Thread Thread Starter Forum Replies Last Post
Discussion GPS V4 expander samir140 Eagle Tree Systems 18 Jul 31, 2014 06:22 AM
Discussion GPS UTC time format in excel lavi Eagle Tree Systems 4 Jun 01, 2010 03:08 AM
Discussion How do you start or get into the DS rhythm? GreenAce92 Dynamic Soaring 29 May 08, 2010 08:10 AM
Discussion How Do You get Into an RC club? clayb62 Beginner Training Area (Aircraft-Electric) 4 Jan 09, 2010 12:47 AM
Careful! Do you get maneauvered into a plane you did not want ? cyclops2 Waterplanes 2 Dec 15, 2009 04:35 PM