How to sum hours in Tfs?

Question

I am required to put in a certain number of hours into TFS for my work items daily.

Currently, I have the following query which shows all the items I worked on during the day:

Is it possible to aggregate all the hours worked TODAY on all tasks. For example, if you go to the ALL CHANGES section of a specific item, you will see details on hours:

Is it possible to aggregate all the hours worked TODAY on all tasks?.

Answer 1

You can make a chart, and select SUM from values section.

Answer 2

ALL CHANGES section is the history of a single work item. There is not a default way to sum the completed work column in TFS. As an alternative, you can export the query to Excel, and sum the completed work column in Excel.

Answer 3

You have two options. One is simpler than the other. As Cece pointed out you can export your query to excel and do the math with excel. In visual studio you can right click on the query and say export to excel. I'm not sure off the top of my head if you can do it in the web interface been awhile since i worked with it. There is another programmatic way to do it but you need access to edit work items as well as installing 3rd party software on the server your TFS instance is installed. Although if you are using the Microsoft hosted version you might be able to install an extension to do this.