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

Code:
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
thanks in advance for any suggestions