How to Set Up an Employee Schedule

by Mike Andrews; Updated September 26, 2017
...

One of the most common chores of managers and business owners is scheduling employees. Each employee's circumstances affect her availability. Filling staffing needs with a schedule can be a weekly challenge, especially when you deal with employee illnesses, emergencies and vacations. Fortunately for managers, creating an employee schedule can be simplified by following a few simple steps.

Items you will need

  • Spreadsheet program
  • Paper and pen or pencil (optional)
Step 1

Open your favorite spreadsheet program such as Microsoft Works, Microsoft Office or Open Office and make eight columns. Label the first column "Name" and the remaining seven columns for the days of the week. Alternately, you can use a pen and paper by folding the paper into eight columns and folding it in half vertically three times.

Step 2

In the first column, list each of your employees' names. The names can be listed in any order, as long as all employees are included. Create a row for each employee.

Step 3

Place an "X" in any cell where an employee will be unavailable. For example, if Mary is unable to work on Wednesday, place an "X" next to her name in the Wednesday column. Blocking out unavailable days will help to shape your schedule and prevent you from accidentally creating schedule conflicts for your employees.

Step 4

Fill in your grid by entering the hours to be worked each day next to each employee's name, with the work hours for each day added in the appropriate column. For example, if David will be working from 9 a.m. to 5 p.m. Monday through Friday, add "9-5" next to David's name in each of those daily columns.

Step 5

Finalize your schedule by reviewing whom you've scheduled to work on each day and making sure that you've added adequate staff to cover all the work hours or shifts required. For example, a business with three working shifts would examine each daily column to be sure that at least one employee was scheduled to work during each work shift. If you require more than one person per shift, adjust your schedule accordingly.

Tips

  • If you don't have a spreadsheet program, download Open Office for a free spreadsheet with complete capabilities.

    Many businesses also review their schedules to be sure that none of their employees has been scheduled for more than 40 hours of work each week.

About the Author

Mike Andrews is a freelance writer and serial entrepreneur focused on small-business and entrepreneurship for average people. He holds a bachelor's degree in biblical studies and a master's degree in theology and has appeared in a wide array of print and online periodicals including "HiCall," "Mature Living" and "Caregivers Home Companion."

Photo Credits

  • Creative Crop/Digital Vision/Getty Images