Done

Done: getting cards completion time

TrelloExport “Done” calculation does not depend upon when a card is marked done on its due date, because there’s no info about this kind of data available trough Trello APIs (we have the due date, but nothing to tell if a card is completed/Done).

A card is considered “done” by TrelloExport when it’s moved to a list which name contains the Done lists name option string: default is “Done”, but you can choose whatever you like) you set in the options dialog. You can even have multiple 'Done' strings, comma separated, like: "Done, Finished".

The Done calculations then consider the card creation, the date when it was moved to a 'Done' lists, and will output these columns to Excel:

• datetimeDone, the datetime of when the card was moved to a 'Done' list
• memberDone, the name of the member who completed the card
• completionTime, the diff between the two dates - a.k.a. card completion time - formatted as per ISO8601 in days, hours, minutes and seconds.

As per ISO8601, a completion time will be expressed like:

P2DT5H4M30S

to mean a duration of 2 days, 5 hours, 4 minutes and 30 seconds.