Peter T wrote on 6/23/2011 :
Thanks but don't see how this approach can be adapted to the OP's task.
Unless I'm missing something which is always possible!

Well I'm not sure it can be adapted if the OP's scenario isn't
structured similar to this concept. My thinking was that the
PeriodTotal formula could be revised to tally time periods rather than
days/months.

All I intended to do here is demo how this can be achieved on a row by
row basis for each entry for any given day. Of course, the demo shows
how it works for each entry for each day, for every day of any month.
The concept is the same but with different period totals.

Basically, each row checks to see if the next row falls within the same
time period. VBA could do this more easily than in cell formulas (in
this OP's scenario) because of the finer degree of the time periods.
And so I thought that presenting this concept would hel give ome ideas
toward a suitable solution.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc