I'm looking to add to my macro, some code so that it will search down
specific column and count how many records there are between each hou
interval.

For example, how many calls between 10AM and 11AM, 12PM-1PM. I jus
wanted to know if there was a way to put code in so that it woul
search down the column and come back with how many automatically.

Here is the thing. The data I'm working with is exported from
program we have. If I go to format cells I can see that it is unde
the "custom" format, using "m/d/yyyy h:mm" If I switch it to general
it comes back as a weird number such as 38916.23. I can change it to
"Date" frmat, but that does not change the contents of the actual cel
which is something like "7/18/2006 5:24:36 AM" I can visibly see i
as I want by formatting it different ways.

Any help would be great!

Thanks,

~

--
nbaj2
-----------------------------------------------------------------------
nbaj2k's Profile: http://www.excelforum.com/member.php...fo&userid=3648
View this thread: http://www.excelforum.com/showthread.php?threadid=56282