I have a spreadsheet with raw data, D column has dates, E column has times.
D2 - 9/25/2013
D3 - 9/25/2013
D4 - 9/24/2013
D5 - 9/23/2013
E2 - 21:53
E3 - 21:48
E4 - 8:12
E5 - 10:46
I would like to have a formula to put in column F that would count how many cells have 9/25/2013 in D as a date and time in E column that has a time between 21:00 - 21:59.
Would this be possible?
Thanks,
Bookmarks