Converting the "Hexoskin time" into normal time in the exported data

Whenever you download your data in binary format from your Hexoskin Dashboard, you will have access to files in .cvs format. If you open one of these files, you will see several columns.  The first column “time [s]” corresponds to the elapsed time since the beginning of your record.

In the "info.json" file, the start date and time is indicated under "start_date":

The start date and time is also indicated under Unix epoch time format. The start time corresponds to the number of seconds since January 1st 1970.

In this example, the start time is 382719153664.

To convert this start time in normal time, you need to divide the start time by 256 to calculate the number of epochs (i.e.382719153664/256 = 1494996694 in this case) then you can convert the resulting number into an epoch & unix converter (i.e. it should give you 1494996694 = Wednesday, May 17, 2017 4:51:34 AM in this case). For more explanations, please refer to this documentation.

However, if you are using the Hxconvertsourcefile software to download your data in the binary format, you can check the box "Save in Posix epoch time (seconds since 1 January 1970)" to have your time converted to epoch directly (therefore no need to divide by 256). This way, the data now in the time column of your "outputrawdata" file can simply be plugged in the epoch & unix converter to give you the actual date.

Keywords: API, UNIX timestamps, data analysis, conversion, hxconvertsourcefile, hxconvert, source, file, hx