Hi!
PLEASE I BEG SUPPORT I AM NEW INVBA!


I have some troubles in VBA,

I need the following

I have an array of dates and time in format : "dd/mm/yyyy hh:mm:ss" (as 84000) I need to set an array of intervals with dates and times in every 10 minutes. Then go to the original array and determine the cells included in each interval and the avergae some values.

I need to determine the first cell and truncate as "dd/mm/yyyy hh:mm"
and then made an array using:
so I can have


For j = 2 To Max
datearray(j) = DateAdd(n, 10, datearray(j - 1))

'ifdatearray(j)>max GoTo GoToHere (el goto here=break)

Next
GoToHere:
End Sub