Appendix 3

Processing rules for converting GPS date and time to real date and time.

Formula: =(A1/86400) +25569

The result will be in GMT (A1 is the cell with the GPS Time data from Rebel).

For other time zones: = ((A1 +/- time zone adjustment) / 86400) + 25569.

For time zone adjustment value:

= ((A1+19800)/86400) +25569 (For Indian Standard Time)

Then format the number to the Custom date and time format:

So, it turns this number from the logger into this date and time:

Last updated 1 year ago