Hi

I am trying to compare a set of times in one cell such as "1200 -
18.00" and then compare this time from another sheet with availability
times such as "13.00 - 17.00" so that I can allocate the right shift
for that person.

What I want to do is to be able to enter a shift and then let excel
accept it using the comparison, or tell me the shift is not suitable.
I am currently using one cell per time slot.

Any ideas would be appreciated.

Thanks