This article explains how to convert the Hexoskin CSV data file timestamps from UNIX to human date and time.
The CSV files of a Hexoskin record or range (activity), the timestamps are formatted as on the image below:
These timestamps can be converted into human-readable date and time values by following the simple steps shown in this article.
Step 1: Conversion Into UNIX Epoch Format
To convert the "Hexoskin" timestamps into "Unix Epoch" timestamps, divide each of them by 256 as seen in the image below:
NOTE: If using Astroskin data, divide the initial "Astroskin" timestamps by 1000 instead of 256.
UNIX Epoch is a widely used timestamp format in computing that encapsulates both date and time as a single numerical value. This number represents the total seconds that have elapsed since January 1, 1970.
Step 2: Conversion Into Human-Readable Time (GMT)
To convert UNIX Epoch timestamps into human-readable date and time format in GMT, first use the following formula:
Human-Readable Time (GMT) = (“Time (Unix)” / 86400) + 25569
Once this is done, on Excel, be sure to then change the data format to "Short Date", "Long Date" and/or “Time” to get an actual Date or Time value.
The image below demonstrates what your timestamps look like once you have completed this step and changed the data format into "Time":
NOTE: You can also use an online UNIX Epoch timestamp converter.
Step 3 (if needed): Conversion Into Your Timezone
If you want to get your timestamps in your specific timezone, you can simply subtract or add the number of seconds from which your timezone is behind or in front of the GMT timezone.
For instance, if your timezone is CDT, which is 5 hours behind GMT, you should subtract 18000 (i.e. -5h * 3600s) from your UNIX GMT value.
You can use this reference to find the proper number of seconds you should add or subtract from the UNIX GMT value to get your specific timezone: https://www.epochconverter.com/timezones
Please don't hesitate to reach out to support@hexoskin.com if you have any questions or need further assistance.