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
Tất cả các câu trả lời (1)
It's Unix timestamp in milliseconds, so you have to convert it using this formula:
=I2 /86400000 + DATE(1970; 1; 1)