I need to know the number of occurrences in a period of time in a certain interval (not sure yet but just need the base formula to work so I can adjust as needed). Every formula I have tried will only result in a 0 even though there are occurrences within the time period. These are the formulas that I have used:
Formula:
=COUNTIFS(B1:B25,">=00:00",B1:B25,"<=00:30")
Formula:
=SUMPRODUCT((D1:D12>=TIME(0,0,0))*(D1:D12<=TIME(0,30,0)))
Formula:
=COUNTIF(D1:D12,">=00:00")-COUNTIF(D1:D12,">01:00")
I am not sure why they are all returning 0's. The actual file has 713 cells to pull from.
Any help is appreciated.
Thanks,
Bookmarks