how to find gaps in the hours scheduled to ensure shift coverage
 

I would like to find gaps in the hours scheduled to ensure that all shifts
are covered and there are employees covering all the hours worked in a given
day - is there a formula, chart, etc. that would allow me to see it instead
of going through manually over each day when scheduling the employee.

how to find gaps in the hours scheduled to ensure shift coverage
 

This may give you what you want; give is a go:
http://peltiertech.com/Excel/Pivots/pivottables.htm

http://www.contextures.com/xlPivot02.html


Regards,
Ryan--

--
RyGuy


"meggy" wrote:

I would like to find gaps in the hours scheduled to ensure that all shifts
are covered and there are employees covering all the hours worked in a given
day - is there a formula, chart, etc. that would allow me to see it instead
of going through manually over each day when scheduling the employee.