Sorry, this is like drawing teeth. We're trying to help you, but we can't
help you if you won't answer the simple questions and if you steadfastly
persist in withholding the information which we'd need to be able to help
you. Hopefully you can sort it out for yourself.
--
David Biddulph

"mavgn" wrote in message
...
david,
it seems it is counting everything after the 06:00 or 07:00 which is
what i tried to say on my last message.
Tom i have also tried your reply i have never used sumproduct before and
have had results within what i am looking for. i am still having some
difficulties but i have to go now till tomorrow afternoon.

thank you both for your help so far.

"David Biddulph" wrote:

You didn't answer my question.
--
David Biddulph

"mavgn" wrote in message
...
i need the result to be numbers/times = to 06:00 but not more than
07:00.
i am going through 24hrs worth of data and want to break it up into
scan's
per 1hr

"David Biddulph" wrote:

If you're struggling to debug your formula, split it up into
manageable
chunks.
=COUNTIF(mon!$D$3:$D$1500,"="&TIME(6,,)) gives you the number greater
than
or equal to 06:00
=COUNTIF(mon!$D$3:$D$1500,"="&TIME(7,,)) gives you the number greater
than
or equal to 07:00
Which of those gives a number different from what you expected?
--
David Biddulph

"mavgn" wrote in message
...
i am newish at excel and am still learning. i have changed that but
it
gives
me "06/08/1902 00:00" as an answer? i change that to genral format
and
it
changes to 949 which i know is way over what i should be looking
for.
=COUNTIF(mon!$D$3:$D$1500,"="&TIME(6,,))-COUNTIF(mon!$D$3:$D$1500,"="&TIME(7,,))


"David Biddulph" wrote:

So presumably you have changed "" to "=" ?
--
David Biddulph

"mavgn" wrote in message
...
i am looking for the number of entries between eg 06:00 and 07:00
or
06:59.
"" is grater than but i need between
"David Biddulph" wrote:

You could use

=COUNTIF(mon!$D$3:$D$1500,""&6/24)-COUNTIF(mon!$D$3:$D$1500,"="&7/24)
or

=COUNTIF(mon!$D$3:$D$1500,""&TIME(6,,))-COUNTIF(mon!$D$3:$D$1500,"="&TIME(7,,))I
am assuming that you have only times in the cells, not dates and
timestogether merely formatted as times.--David Biddulph"mavgn"
wrote in
...i
am
tring to get excel to count the number of entries of certain
times
anda
worksheet. but the format is time eg 06:15 and i want it to look
for
the
number of entries from "06". can anyone help.
=countif(mon!$D$3:$D$1500,"06*") is what i have got to so far
but
itsbecause the details that it is looking at are in time
format. I
dont
want to haveto manualy change all the times to text which would
work
but
takes to long.