How can I extract the time spent executing test cases?
I need to extract the time in hh:mm:ss spent by testers to execute the test cases in my Quality Center 11 project.
I know some basic SQL but have not been able to locate the fields I need if I need to calculate the value myself. QC stores at least one time stamp that has to do with test execution time, and it may be the time the test case was initiated. So I would need to locate one indicating when the test case was finished.
There is another field that may be the one I need: it's called rn_duration, and I have found out it stores the time in ms., but the contents look somewhat suspect, i.e. 2000 ms in several cases. Is this the right field?