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.