Thread: Countif time
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
S.C S.C is offline
external usenet poster
 
Posts: 6
Default Countif time

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