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
Todas as respostas (1)
It's Unix timestamp in milliseconds, so you have to convert it using this formula:
=I2 /86400000 + DATE(1970; 1; 1)
É necessário entrar na sua conta para responder a publicações. Faça uma nova pergunta, se ainda não tiver uma conta.