excel weekly work schedule per route template

#Excel weekly work schedule per route template how to#

Let's start by calculating the work hours on the far right.

In this case, we're going to calculate the number of hours each person works and how many people come to work during those hours, so we're going to create a column to display the calculation results in the right-hand side and bottom of the Excel table we just created. Create a column for the total number of people In the sample, I made a table with the 'type', 'name', 'task', 'start time', 'end time', and 7:00-11:00 pm to distinguish between full-time and part-time employees.ģ.

We'll design the whole thing later, and create a table of people and hours for the shift. Let's create a 30 pixels wide by 30 pixels high. The first thing to do is to adjust the size of the vertical and horizontal cells in Excel.īy default, the width is too long, so when you create a calendar for the front part of the shift table, you can't get enough dates. The automatic calculation is based on the number of people in the shift and the number of hours worked that day.

There are various ways to make a shift chart, but in this article, I will try to create a shift chart like the one below, which automatically calculates the number of people in a shift for a day.

#Excel weekly work schedule per route template how to#

If you want to make your own Excel shift chart instead of a template, here's how to make a shift chart. Fa-arrow-circle-rightDownload How to make a shift schedule in Excel