Summing the results of a queery
![](http://jazz.net/_images/myphoto/a1ea0c1d9a3d19541447940c505b521e.jpg)
4 answers
![](http://jazz.net/_images/myphoto/a1ea0c1d9a3d19541447940c505b521e.jpg)
does anyone know how this could be done,
for example generating a list of hours worked on various work items by
a person and then adding together the hours returned
I believe the Iteration Plans already provide this data for each team
member.
Otherwise, you could export a query as a CSV spreadsheet and sum up the
values in Excel.
--
Regards,
Patrick
Jazz Work Item Team
![](http://jazz.net/_images/myphoto/a1ea0c1d9a3d19541447940c505b521e.jpg)
Ok thanks I'll have a look at that
---------------
I believe the Iteration Plans already provide this data for each team
member.
Otherwise, you could export a query as a CSV spreadsheet and sum up the
values in Excel.
--
Regards,
Patrick
Jazz Work Item Team
---------------
does anyone know how this could be done,
for example generating a list of hours worked on various work items by
a person and then adding together the hours returned
I believe the Iteration Plans already provide this data for each team
member.
Otherwise, you could export a query as a CSV spreadsheet and sum up the
values in Excel.
--
Regards,
Patrick
Jazz Work Item Team
![](http://jazz.net/_images/myphoto/a1ea0c1d9a3d19541447940c505b521e.jpg)
I would like to export queries about work items and th etime spent or estimated to a spreadsheet. But the export fucntion generates out put like '2 day', 4'hours',.. That can not be summed up, so I have to manually chaneg this to a number of hours.
Is there a way arond it?
sorry, i asked taht alread y and foudn teh answer :?