Can someone please help? I have some time/date data that
I bring over to Excel from Access that is formatted like
this: 8/30/2004 6:36. What I am trying to accomplish is
to give me the total number of calls say between 6:30 am
and 7:30 am, 7:31 am through 8:30, etc. The problem is
that if I try to extract the time, it gives me weird
numbers (when I format it for numbers, it gives me
38229.27523, which I am assuming is the number value for
Excel for this date). I know how to do VLOOKUPS, but I
can't get it to work because the date/time is not
formatted right. I have tried to format it every way,
but it still doesn't work. Any advice? Thanks!