Avatar for Username

Pretraži podršku

Izbjegni prevare podrške. Nikad te nećemo tražiti da nas nazoveš, da nam pošalješ telefonski broj ili da podijeliš osobne podatke. Prijavi sumnjive radnje pomoću opcije „Prijavi zlouporabu”.

Saznaj više

Export Passwords

  • 1 odgovor
  • 0 ima ovaj problem
  • 10 prikaza
  • Posljednji odgovor od TyDraniu

jojomeyers
jojomeyers
more options

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

Svi odgovori (1)

TyDraniu
TyDraniu
  • Top 10 Contributor
more options

It's Unix timestamp in milliseconds, so you have to convert it using this formula: 

=I2 /86400000 + DATE(1970; 1; 1)

Korisno?

Postavi pitanje

You must log in to your account to reply to posts. Please start a new question, if you do not have an account yet.