Try this:

=COUNTIF(S4:S128,TIMEVALUE("0:08"))

or this:

=COUNTIF(S4:S128,TIME(0,8,0))

Times are stored internally by Excel as fractions of a 24-hour day, so
you need to compare like with like.

Hope this helps.

Pete

On Mar 28, 2:08 am, "S.C" wrote:
I have a column of time (0:08) I would like to count the amount of times the
time of 0:08 (for example) but I cannot get my formula of
=COUNTIF(S4:S128,"0:08") to count. This column is a subtraction of two times
=B4-E4, I copy and Paste Special the value into column "S"

Thanks in advance for the assistance
Steve

I have a column of time (0:08) I would like to count the amount of times the
time of 0:08 (for example) but I cannot get my formula of
=COUNTIF(S4:S128,"0:08") to count. This column is a subtraction of two times
=B4-E4, I copy and Paste Special the value into column "S"

Thanks in advance for the assistance
Steve

Try this:

=SUMPRODUCT(--(C1:C7<=--"0:08"),--(C1:C7--"0:07:59"))


"S.C" wrote:

Pete,

Thanks for the formulas .... but neither of them worked .... I am going to
try and convert the time into a text number and see if that will work.

Thanks again

"Pete_UK" wrote in message
oups.com...
Try this:

=COUNTIF(S4:S128,TIMEVALUE("0:08"))

or this:

=COUNTIF(S4:S128,TIME(0,8,0))

Times are stored internally by Excel as fractions of a 24-hour day, so
you need to compare like with like.

Hope this helps.

Pete

On Mar 28, 2:08 am, "S.C" wrote:
I have a column of time (0:08) I would like to count the amount of times
the
time of 0:08 (for example) but I cannot get my formula of
=COUNTIF(S4:S128,"0:08") to count. This column is a subtraction of two
times
=B4-E4, I copy and Paste Special the value into column "S"

Thanks in advance for the assistance
Steve

Pete,

Thanks for the formulas .... but neither of them worked .... I am going to
try and convert the time into a text number and see if that will work.

Thanks again

"Pete_UK" wrote in message
oups.com...
Try this:

=COUNTIF(S4:S128,TIMEVALUE("0:08"))

or this:

=COUNTIF(S4:S128,TIME(0,8,0))

Times are stored internally by Excel as fractions of a 24-hour day, so
you need to compare like with like.

Hope this helps.

Pete

On Mar 28, 2:08 am, "S.C" wrote:
I have a column of time (0:08) I would like to count the amount of times
the
time of 0:08 (for example) but I cannot get my formula of
=COUNTIF(S4:S128,"0:08") to count. This column is a subtraction of two
times
=B4-E4, I copy and Paste Special the value into column "S"

Thanks in advance for the assistance
Steve

OK .. I will try that one in the morning ... Thanks


"Teethless mama" wrote in message
...
Try this:

=SUMPRODUCT(--(C1:C7<=--"0:08"),--(C1:C7--"0:07:59"))


"S.C" wrote:

Pete,

Thanks for the formulas .... but neither of them worked .... I am going
to
try and convert the time into a text number and see if that will work.

Thanks again

"Pete_UK" wrote in message
oups.com...
Try this:

=COUNTIF(S4:S128,TIMEVALUE("0:08"))

or this:

=COUNTIF(S4:S128,TIME(0,8,0))

Times are stored internally by Excel as fractions of a 24-hour day, so
you need to compare like with like.

Hope this helps.

Pete

On Mar 28, 2:08 am, "S.C" wrote:
I have a column of time (0:08) I would like to count the amount of
times
the
time of 0:08 (for example) but I cannot get my formula of
=COUNTIF(S4:S128,"0:08") to count. This column is a subtraction of
two
times
=B4-E4, I copy and Paste Special the value into column "S"

Thanks in advance for the assistance
Steve