Welcome To Our Support Portal

Browse Impinj resources for help with FAQ, downloads, quick links, and more.


Submit a request

Converting MultiReader's Tag History epoch time

Follow


MultiReader's tag history files contain a 13 digit time stamp that represents the number of seconds that have passed since 1/1/1970.
 
Below is an excel formula that converts the epoch time in MultiReader to a standard time format we can all understand. After using the formula, you will need to format the cell for date and time.
 
=(((A1-(6*3600))/86400)+25569)
 
A1 = cell reference
6 = Timezone Offset (this is Central Standard time / Mountain Day Light Savings Time)
3600 = Number of seconds in an hour
86400 = Number of seconds in a year
25569 = Excel hack because excel counts epoch from 1/1/1900 and most others start at 1/1/1970.
 

Was this article helpful?
0 out of 0 found this helpful

Comments

Impinj (NASDAQ: PI) wirelessly connects billions of everyday items such as apparel, medical supplies, and automobile parts to consumer and business applications such as inventory management, patient safety, and asset tracking. The Impinj platform uses RAIN RFID, delivering information about items to the digital world and enabling the Internet of Things.