Countif time

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

S.C - 28 Mar 2007 00:52 GMT

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

Reply to this Message

Pete_UK - 28 Mar 2007 01:26 GMT

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

> 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
[quoted text clipped - 3 lines]
> Thanks in advance for the assistance
> Steve

Reply to this Message

S.C - 28 Mar 2007 03:11 GMT

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

> Try this:
>
[quoted text clipped - 18 lines]
> > Thanks in advance for the assistance
> > Steve

Reply to this Message

Teethless mama - 28 Mar 2007 03:58 GMT

Try this:

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

> Pete,
>
[quoted text clipped - 27 lines]
> > > Thanks in advance for the assistance
> > > Steve

Reply to this Message

S.C - 30 Mar 2007 02:54 GMT

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

> Try this:
>
[quoted text clipped - 31 lines]
> > > > Thanks in advance for the assistance
> > > > Steve

Reply to this Message