software

I have a column containing date and time, for example:

10/13/2006 7:30:00 PM

I'm trying to count the instances of specific times (i.e. how many 7:30 pm's
or 3:00 pm's).

Tried COUNTIF(D,quot;7:00:00PMquot;), but that doesn't work, I'm guessing because
the date and time are all one numeric string in Excel ... but I don't know
how to search and count just the time portion.

Any help appreciated!

Try something like this:

With a list of date/time values in A1:A10

B1: =SUMPRODUCT(--(ROUND(MOD(A1:A10,1),6)=ROUND(--quot;7:30:00 PMquot;,6)))

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Proquot;Rob Odumquot; wrote:

gt; I have a column containing date and time, for example:
gt;
gt; 10/13/2006 7:30:00 PM
gt;
gt; I'm trying to count the instances of specific times (i.e. how many 7:30 pm's
gt; or 3:00 pm's).
gt;
gt; Tried COUNTIF(D,quot;7:00:00PMquot;), but that doesn't work, I'm guessing because
gt; the date and time are all one numeric string in Excel ... but I don't know
gt; how to search and count just the time portion.
gt;
gt; Any help appreciated!

Like a charm ... thanks!!!!

quot;Ron Coderrequot; wrote:

gt; Try something like this:
gt;
gt; With a list of date/time values in A1:A10
gt;
gt; B1: =SUMPRODUCT(--(ROUND(MOD(A1:A10,1),6)=ROUND(--quot;7:30:00 PMquot;,6)))
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;Rob Odumquot; wrote:
gt;
gt; gt; I have a column containing date and time, for example:
gt; gt;
gt; gt; 10/13/2006 7:30:00 PM
gt; gt;
gt; gt; I'm trying to count the instances of specific times (i.e. how many 7:30 pm's
gt; gt; or 3:00 pm's).
gt; gt;
gt; gt; Tried COUNTIF(D,quot;7:00:00PMquot;), but that doesn't work, I'm guessing because
gt; gt; the date and time are all one numeric string in Excel ... but I don't know
gt; gt; how to search and count just the time portion.
gt; gt;
gt; gt; Any help appreciated!