i am tring to get excel to count the number of entries of certain times and a
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 its because
the details that it is looking at are in time format. I dont want to have to
manualy change all the times to text which would work but takes to long.