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.