It's all about the answers!

Ask a question

How to sum All Time Spent Hours?


shirit Kidron (111539) | asked Apr 03 '14, 1:53 a.m.
edited Apr 03 '14, 4:43 a.m. by Krzysztof Kaźmierczyk (7.4k35799)

Hi,

I want to sum up all "Time Spent" hours of WI  of a month(Not Iteration).

Iteration can be for example from 20/3-4/4.

I need to pars the history of each WI and to Filter the houres of the specific month and to sum up the hours.

How can I do that?

How can i run query on the RTC DB and to perform calculations like this one?

2 answers



permanent link
sam detweiler (12.5k6189201) | answered Apr 03 '14, 6:41 a.m.
Queries have no support for math operations. you will need a Report . (Birt or something bigger)



Comments
shirit Kidron commented Apr 06 '14, 3:37 a.m. | edited Apr 07 '14, 2:32 a.m.

 Hi,


The math calculation I can do in excel after I will export the query results. But How can I get the history of a task to a query result or To Pars the history file? 


permanent link
Robert Macklyn (6) | answered Apr 08 '14, 1:57 p.m.
Well in this case I personally prefer using the cloud based hours tracking tool from Replicon that keeps track of the single hour spent in a particular task and manage them to add up to give up a generic result to the end user.

Your answer


Register or to post your answer.