??????????Σ??????????????Σ??????????????????????????bug?????????????????ε??Щ???.?????????У????????????????????????г??????bug????????bug????????????ж???.

????????

??????????bug?????bug???????????

???????????bug?????bug??????????????

????????

????????????????????????????????????

????1?????????????bug??????????????????

????2????????????????????????????

????2.1 ??????????????????bug???????????????????????????????????????????????????????????????ε?bug???????????????ζ?????????????????????????????估?????

????2.2 ???????????bug???????????????????????????????????????????????????????????????飬??????????????????????Ч??????

????2.3 ??????????????????????????????????????????????????????????????

????3??????????????????Э???????????????????????????????????????????????????????Э???????????

??????

??????bug??????????bug????????磺2010-11-03 12??34??34-----time_created

??????bug???????????bug??resolve?????-----time_resolved

??????bug???????????????bug???????????----time_tested

????????????=time_resolved-time_created?????????

???????????=time_tested-time_resolved?????????

?????????????????????bug???????????

???????????

???????????????У??????excel?????????估???????????????????excel?е?VBA????

Public getTime(a?? b)
On orror GoTo 1
Dim weeka As Integer
Dim weekb As Integer
???????????????????????幤???????????????????????daywork=24*2??????????8С?????hourwork=24-8
Const dayWork As Integer = 24?? hourWork As Integer = 16
weeka = Application.Worksheet.WeekNum(a)
weekb = Application.Worksheet.WeekNum(b)
getTime = (b - a) * 24 - (weekb - weeka) * dayWork - Int(b - a) * hourWork
Exit
1:
getTime = 0
End


?????????????????????????????????

?????????????????????????