Hello,

I try to add some hour:minutes (string formated) values in vba, but I doesn't work when I use strings like "101:10" (here I get an "type intolerance" error).

For example:
E9: "0:30"
E10: "15:45"
E11: "101:10"

With the local formula "=DATWERT(E9)+ZEITWERT(E9)+DATWERT(E11)+ZEITWERT(E11)+DATWERT(E12)+ZEITWERT (E12)" in H1 I get the right value "117:25" (format: [hh]:mm).

But my vba test-code:
Dim test As Range

For Each test In mylistobject.AutoFilter.Range.Columns(5).SpecialCells(xlCellTypeVisible).Cells.Offset(1, 0)
  debug.print DateValue(test.Value2) + TimeValue(test.Value2)
Next test
throws an error when i access the E11 cell ("101:10"). It seems that DateValue/TimeValue works slighty different than the german functions.
I tried also DateValue(CDate(test.value2)) - but it doesn't worked too.

Any help is welcome

Thank you,
Thomas