Quality Center calculate the Actual Fix Time in days. Is there a method to calulate the defect age in minutes, hours, etc.?
Answer by SammyH · Feb 07, 2012 at 12:22 PM
Quality Center does not store the timestamp in the
BG_DETECTION_DATE field, only the date.
You can create two new user fields to store the beginning and ending timestamps as Stings.
BG_USER_01 / Label: TS_Opened BG_USER_02 / Label: TS_Closed
BUG_NEW subroutine, populate the opened timestamp with this code.
BUG_AFTER_POST subroutine, populate the closed timestamp with this code.
If Bug_Fields.Field("BG_STATUS").Value = "Closed" Then If Len(Bug_Fields.Field("BG_USER_02").Value) = 0 Then Bug_Fields.Field("BG_USER_02").Value=CStr(Now()) Post End If End If
You could also create yet another field to store your defect age, ie
The defect age in minutes is calculated by:
The defect age in hours calculated by: