Avatar for Username

Cari Bantuan

Avoid support scams. We will never ask you to call or text a phone number or share personal information. Please report suspicious activity using the “Report Abuse” option.

Pelajari Lebih Lanjut

Export Passwords

  • 1 balas
  • 0 memiliki masalah ini
  • Balasan terakhir oleh 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

Semua Balasan (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)

Membantu?

Ajukan pertanyaan

Anda harus masuk ke akun Anda untuk membalas kiriman ini. Sila mulai pertanyaan baru, jika Anda belum memiliki akun.