Avatar for Username

Iskanje po podpori

Izogibajte se prevarantski tehnični podpori. Nikoli vam ne bomo naročili, da pokličete telefonsko številko ali nam pošljete osebne podatke. Sumljivo dejavnost prijavite z gumbom »Prijavi zlorabo«.

Več o tem

Export Passwords

  • 1 odgovor
  • 0 ima to težavo
  • Zadnji 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

Vsi odgovori (1)

TyDraniu
TyDraniu
  • Top 25 Contributor
more options

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

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

Koristno?

Vprašajte

Če želite objaviti odgovor, se morate prijaviti v svoj ​​račun. Če računa še nimate, zastavite novo vprašanje.