Countif time

P

Pete_UK

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
 
S

S.C

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
 
S

S.C

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
 
Top