Join the AMA (Ask Me Anything) with the Firefox leadership team to celebrate Firefox 20th anniversary and discuss Firefox’s future on Mozilla Connect. Mark your calendar on Thursday, November 14, 18:00 - 20:00 UTC!

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 reply
  • 0 have this problem
  • Last reply by 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 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)

Helpful?

Ask a question

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