Hi guys,
i have list of events that are time stamped. I need a formula within excel to automatically count the no. of events between, for example, 10:00 and 11:00 etc. Being a newbie, i used the countif formula,example,
=COUNTIF(D:D,"<01/01/2005 01:00")
and the same for the next hour and deducted the result. However, this is very time consuming when i have to do it for each hour, so i need something much faster and easier. Hope i get an answer soon.
Thanx