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)
投稿に返信するには あなたのアカウントにログイン する必要があります。まだアカウントをお持ちでなければ、新しい質問を開始 してください。