Exporting query with estimate and actual effort as integers
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.
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
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.
I'm not sure there's a way to do the same thing from the web.