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.