Important Notice: We're experiencing email notification issues. If you've posted a question in the community forums recently, please check your profile manually for responses while we're working to fix this.

Avatar for Username

Search Support

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.

Learn More

Export Passwords

  • 1 antwoord
  • 0 hierdie probleem
  • 36 views
  • Laaste antwoord deur 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

All Replies (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)

Helpful?

Vra 'n vraag

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