Export Passwords
When I export Passwords the file has 3 col timeCreated timeLastUsed timePasswordChanged
that do not show as date or time format - I try formatting in excel and no good.. Yes I hit convert when opening the csv vis excel Thank you
When I export Passwords the file has 3 col timeCreated timeLastUsed timePasswordChanged
that do not show as date or time format - I try formatting in excel and no good.. Yes I hit convert when opening the csv vis excel
Thank you
所有回覆 (1)
It's Unix timestamp in milliseconds, so you have to convert it using this formula:
=I2 /86400000 + DATE(1970; 1; 1)