gps time format
How can I convert GPS time (the number of seconds since Jan 06, 1980) into the traditional date/time format?
How can I convert GPS time (the number of seconds since Jan 06, 1980) into the traditional MM/DD/YY HH:MM:SS.000 format?
The tricky part is that it needs to be precise– does anyone have/know of any code or applet that can convert 820099698.834957 into a meaningful date and time?
I think I can help you.
Do you have MS Excel? If so, there are date and time conversions included. You can enter a number into a cell, and have Excel convert to a date, or vice versa. And the same is true for time. It is important to understand that Excel uses Jan 1, 1900 as its start date though. That is day number 1 in Excel.
This is what I did to solve your problem:
1) take your input and divide it by 86400 sec/day, getting 9491.894662 days
2) enter 1/6/1980, your GPS start date, and convert to a day number, getting 29226.000000
3) add the two together, getting 38717.894662
4) use Excel to convert that to a date, getting 12/31/05
5) take the fractional part of 3) above, 0.894662
6) find the time of day for 5), getting 21:28:19
7) your complete answer: 12/31/05 21:28:19
It is easy enough to set up a simple spreadsheet to solve for any number of seconds past the GPS start date.
Hope this helps. Good luck.
