Lets say i do this to count the number of that particular hour:
If vDateTime.Hour > 0 And vDateTime.Hour < 24 Then
Dim hour As Integer = vDateTime.Hour
If hour = 0 Then
hour = 24
End If
count(hour, 0) = count(hour, 0) + 1
Refer to the data below:
1.2008/06/24 02:00
2.2008/06/24 12:00
3.2008/06/24 06:00
4.2008/06/24 17:00
5.2008/06/25 06:00
The first will be allocated to hour=02 and the second one will go to hour=12.
However i face this problem: How if 3 and 5 having the same hour but different date? I need to get the date as well. Can i solve this problem using almost the same coding format above? I need to keep count(hour, 0) = count(hour, 0) + 1 this way. Thanks a lot.