calculate the numbers based on Time

[Rajesh123469]

I have set of numbers created Like
Time numbers
00:15:00 2
00:20:00 4
01:00:00 6
-------
---

How to calculate the numbers in above 1 hour in visual basic

Thanks
Rajesh

[debasisdas]

what is the logic for the calculation ?

[Rajesh123469]

I have number of records in every hour, I want to calculate the records in every hour time and display in sheet.

like,

Time records
--------- -------------
1:00 AM 3
1:15 AM 4
1:30 AM 7
2:00 AM 2
2:30 AM 2
3:00 AM 10

In this, I have to calcute the records in 1:00AM to 2:AM and 2AM to 3AM in visual basic?

Can you please help me, It's urgent

Thanks in Advance..