hi i'm having trouble with my code
[CODE=vb]If lblNumberArray( i) = lbltmpNumber Then
EndTime = Now
lblEnd(i).Capti on = Format(EndTime, "hh:mm:ss")
StartTime = lblTime(i)
Timeduration = ((DatePart("n", EndTime) - DatePart("n", StartTime)) * 60) + (DatePart("s", EndTime) - DatePart("s", StartTime))
lblDuration(i). Caption = "" & Timeduration
Counter = Counter + 1
lblNum.Caption = "" & Counter
End if[/CODE]
What i'm trying to do here is whenever time duration is display. The Counter will increase by 1 but i'm facing problem here. The Counter never increase when time duration is display. Besides that i dont know how to do coding to total the values in time duration array.
[CODE=vb]If lblNumberArray( i) = lbltmpNumber Then
EndTime = Now
lblEnd(i).Capti on = Format(EndTime, "hh:mm:ss")
StartTime = lblTime(i)
Timeduration = ((DatePart("n", EndTime) - DatePart("n", StartTime)) * 60) + (DatePart("s", EndTime) - DatePart("s", StartTime))
lblDuration(i). Caption = "" & Timeduration
Counter = Counter + 1
lblNum.Caption = "" & Counter
End if[/CODE]
What i'm trying to do here is whenever time duration is display. The Counter will increase by 1 but i'm facing problem here. The Counter never increase when time duration is display. Besides that i dont know how to do coding to total the values in time duration array.
Comment