Hi J

The "weird number" is date-time, see
http://www.cpearson.com/excel/datetime.htm
for some theory.

As for the interval count, and all other kinds of summaries, a Pivot table
will do it for you. See
http://www.mrexcel.com/tip047.shtml

(If you haven't used Pivot tables before, it may look too foreign and scary
and you'll post back for another solution. But take my word for it: Spend
half an hour learning Pivot tables and you can't imagine how you ever
managed without them.)

HTH. best wishes Harald

"nbaj2k" skrev i
melding ...

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

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

Here is the thing. The data I'm working with is exported from a
program we have. If I go to format cells I can see that it is under
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 a
"Date" frmat, but that does not change the contents of the actual cell
which is something like "7/18/2006 5:24:36 AM" I can visibly see it
as I want by formatting it different ways.

Any help would be great!

Thanks,

~J


--
nbaj2k
------------------------------------------------------------------------
nbaj2k's Profile:
http://www.excelforum.com/member.php...o&userid=36480
View this thread: http://www.excelforum.com/showthread...hreadid=562821