CODEWITHSUNDEEP
visual-studiotfs
Alex Gordon
Alex Gordon

Reputation: 60751

How to sum hours in Tfs?

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:

enter image description here

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:

enter image description here

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

Upvotes: 8

Views: 7930

Answers (3)

Cetin Yilmaz
Cetin Yilmaz

Reputation: 176

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

enter image description here

Upvotes: 8

Cece Dong - MSFT
Cece Dong - MSFT

Reputation: 31023

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.

enter image description here

Upvotes: 3

Josh C.
Josh C.

Reputation: 316

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.

Upvotes: 1

Related Questions