Is it possible to write a TFS request to get the actual time for tasks?

Question

I use TFS to track my backlog items, and now I'm trying to write a query to find out how long I have been doing specific tasks in the last 7 days. So far, I have this query:

Work Item Type = Task

And state = Done

And closed date = @ Today - 7

And area path = @Project

And assigned = @Me

and added the column "Closed Date", which shows that the running time is stopped on this element. But I can’t get any information about when the work onTask

It seems that the data should be there, as for specific tasks, it has the following information:

Is it possible? I do not mind retrieving data in Excel for analysis.

, , , , , , , , .

Answer 1

TFS . API TFS , , .

, - , . , , , , .

Answer 2

. .

(Work Item Type = User Story
OR Work Item Type = Bug
)
AND State <> New
AND State <> Removed

Activated Date, Resolved Date Closed Date . Activated Closed - .

Resolved " ", Resolved to Closed , , "done" to "in prod".