I am trying to create an employee schedule in Excel that is easy to use. I tried modifying the one that's available on the office template, but can't get it right. Here is what I am looking for:

- Easy to input
- Visually assess who is working each day and at what times
- Calculates the number of hours each employee is working
- Elminates the need to manually write the schedule first

If anyone has anything like this already or can point me in the right direction, it would be greatly appreciated.

Thanks,
Nadia