I am creating a work schedule for my employees and I would like to know if there is formula I can use when creating the work day schedule to tell me if all the hours through out the work day are filled.

For example

8am - 10pm must be filled.

If I have an employee scheduled to work from 8am - 4pm and one to work from 4pm - 10pm then the cell would be "True" but if a timeframe were empty say 3pm - 4pm the cell would be "False"