It's all about the answers!

Ask a question

Exporting query with estimate and actual effort as integers

ed Neubecker (15322847) | asked Oct 22 '13, 12:59 a.m.
A query that includes Estimate and Actual data on work items show up as string data in a the CSV export when the query is exported. (example :  32h, 12h, 16m).
Is there a way to drop the units from this field so this data will show up as integer data in the CSV export? 
The current format makes it difficult to work with in excel as these fields are text strings and not integers.

Accepted answer

permanent link
Brian Fleming (1.6k11928) | answered Oct 22 '13, 12:33 p.m.
In Eclipse, you can do File -> Export -> Team -> Work Items.  After selecting your query click "Next".  In the "Show" column change the "Label" setting to "Internal Value" for the estimate and actual attributes.  This will give you an integer in milliseconds in the resulting csv.

I'm not sure there's a way to do the same thing from the web.
ed Neubecker selected this answer as the correct answer

One other answer

permanent link
leon mo (1113) | answered Apr 20 '16, 4:46 a.m.
Anyone know is it a way to do it on web client?

Your answer

Register or to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.