Lockwise Exported Date/Time Format?
I exported logins/passwords to a .csv file and imported each field as Text into Excel. The data includes several date/times such as Last Used Date. The Date/Times are just large numbers like I might find if they were the number of milliseconds since Jan. 1, 1970. Does anyone know what the date/time format used is? I'll ask in an Excel forum how to convert it to something more human friendly.
Chosen solution
Those dates are in Unix Epoch format in microseconds since January 1, 1970.
It looks that you can easily do this in Excel with a function to decode such a number.
Note that you likely need to increase the 86400 multiplier to make this work with microseconds, so just add a few (three,six) zeros until the dates look right.
Read this answer in context 👍 1All Replies (2)
Chosen Solution
Those dates are in Unix Epoch format in microseconds since January 1, 1970.
It looks that you can easily do this in Excel with a function to decode such a number.
Note that you likely need to increase the 86400 multiplier to make this work with microseconds, so just add a few (three,six) zeros until the dates look right.
Modified
You are awesome! Thanks!