Summing the results of a queery
![]()
Hi there
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 thanks Paul |
4 answers
![]() does anyone know how this could be done, 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 |
![]()
Ok thanks I'll have a look at that
--------------- does anyone know how this could be done, 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 |
![]()
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? |
![]() 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. sorry, i asked taht alread y and foudn teh answer :? |