# 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:

<https://www.epochconverter.com/timezones>

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

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

<div align="left"><figure><img src="https://3979528544-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FFiflr3JdTVky5EaTMlxu%2Fuploads%2FocqPYaGsEbRJ5BX0en0C%2Fimage.png?alt=media&#x26;token=a49c31e5-6b1e-42f6-a0ae-87130337530e" alt="" width="563"><figcaption></figcaption></figure></div>

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

<img src="https://3979528544-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FFiflr3JdTVky5EaTMlxu%2Fuploads%2F2OQ7eSgK5IjRXPq7TAl5%2Fimage.png?alt=media&#x26;token=e121d37e-6618-4f8b-ac81-34a4587aec34" alt="" data-size="original">