I have a worksheet with a months worth of data, listing calls to the company
each day. Each call has an 'Effective Date and Time' in the format of
01/01/2007 08:20:31 and I am interested in seeing how many calls come in
between 07:30 and 18:00 over the month. I have duplicated the 'Effective
Date and Time' column and formatted it to show just the time as hh:mm, that
has worked fine, what I now need to do is figure out how many fall into my
time period of 07:30 - 18:00, I don't want to have to count each entry (there
are 1104 for January and I have all of 2007 to do!) so would appreciate any
help anyone can offer.
Thanks in anticipation!!
Philip