The attached was setup recently to do this over a days period, if your data is for one day only then you would need columns B and C only and reduce the SumProduct accordingly to (in C3, then formula-fill)Originally Posted by jamboc
=SUMPRODUCT(--(MOD($A$3:$A$53,1)<$B3)*(--(MOD($A$3:$A$53,1)>=$B2)))
Hope this helps
---
Bookmarks