Welcome Guest,Register Now
Log In

ANT Forum

Welcome guest, please Login or Register

   

How do I convert timestamp?

Rank

Total Posts: 4

Joined 2015-12-14

PM

I have a fit file and using the FIT SDK 20.41.00 (FitToCSV.bat). I get a CSV file generated. I open the CSV file with Excel and under TIMESTAMP I see (for example) '869948234'. The question is "Using Excel formulas, how do I convert this to date/time for Pacific time zone?"
Thank you in advance.
Rick      
RankRankRank

Total Posts: 68

Joined 0

PM

( ( TIMESTAMP 631065600 ) / 86400 ) + 25569 


Formatted as a "Date" in Excel should do what you need      
Rank

Total Posts: 4

Joined 2015-12-14

PM

That did it! Thank you sir!