VBA Excel Time/Date Question

I am hoping some one can help. Learned VB 10 years ago and am a little rusty.

I have a spreadsheet with date/time in a column. Each date/time has a value associated with it in another column.

What I am looking to do is to sum the values that occur in an hour or less and have that summed value populate a cell in the proceeding column. Not concerned about values that are associated with durations greater than 1 hour.


Date/Time Value
7/27/07 5:33 PM 0.00
7/27/07 7:51 PM 0.04
7/27/07 8:28 PM 0.04
7/27/07 11:08 PM 0.00
7/27/07 11:57 PM 0.08
7/28/07 12:11 AM 0.04
7/28/07 12:23 AM 0.06
7/28/07 12:50 AM 0.04
7/28/07 2:46 AM 0.04
7/28/07 5:30 AM 0.04
7/28/07 5:27 PM 0.04

Thanks for any assistance.
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories