How to Make a Work Schedule for Employees in Excel - Tutorial

Do you have a formula stating the work schedule based on you template? Example 8am to 4pm

Any chances of creating a video on a solution that would automate employee scheduling based on availability?

Thank you

Man this is so close to what I am trying to do. Except I am trying to make a simple schedule on one sheet that you put in the shift EX: 8AM-4PM and then have excel auto populate your graphs.