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