Could someone please help with this CountIF issue

Hi all,

Please someone save me with this one.

I have a load of cells with shifts in e.g 0600-1300

I am trying to get another cell to return a count of purely the start time of the shift. At the moment I have put the following formula in;

=COUNTIF(C3:C87, "0600-1300")

This returns the count I want but not all shifts are 0600-1300 and I need to know all people that are in at 0600.

I fear I know the answer, which is to split the cells, one having 0600 and the other having the finish time, but that is a huge amount of work and I don't have the time, so i'm hoping someone with hugely better knowledge of excel can help.

Thanks in advance with any help you can give.

You'll want to slip a wildcard in there.

Please Login or Register  to view this content.

The asterisk will accept anything after that point in a text string (the way these times are formatted is considered a text string).

Edit: You can also do the inverse, if you wanted to see who leaves at 1300.

Please Login or Register  to view this content.

Legend! Thank you. Saved me so much work and helps my time. Thanks

Thanks ALL