Hi there,
I'm look for a VBA Excel code to make a SumIfs with time criteria.
I'm using a range of cells with 258700 rows and I'm trying to do like this.
Sheets("CALC").Cells(LShClc, 24) = WorksheetFunction.SumIfs(MyRangeDuration, MyRangeMachine, Maq, MyRangeCode, 200, MyRangeBTime, (">=" & "05:50:00" and "<=" & 14:10:00"))
It's not recognize the times when I put ">=" signal, only runs if I put "=".
Please help me to solve this code.
