Hi,
I am trying to add the time values from part of an array. the array is 0 to 27 but I only want to add parts of it and have it displayed in lanaweek1. I am getting an error on line 1 of the code below, saying type mismatch. The lanatotal(i).text is in "hh:mm" format
thanks in advance for any suggestionsCode:Private Sub lanatotal_Change(Index As Integer) timetoadd = TimeValue(lanatotal(0).Text) + TimeValue(lanatotal(1).Text) + TimeValue(lanatotal(2).Text) lanaweek1 = Format(timetoadd, "hh:mm") End Sub




Reply With Quote