How to Make a Work Schedule in Excel (+ Free Online Alternative)

Step 1: Set up your spreadsheet

Open Excel and create a new blank workbook. Your first task is to define the grid structure:

• Leave cell A1 empty — this is your top-left corner.
• In row 1, enter the days of the week starting from B1: Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday.
• Optionally include a column for Total Hours at the end (e.g. column I).

Freeze the header row (View → Freeze Panes → Freeze Top Row) so it stays visible as you scroll down.

Step 2: Add your employees and days

In column A (starting from A2), list your employees — one name per row. If you have many employees, consider grouping them by department or role.

Pro tip: Bold the employee names and adjust the column width so full names are visible. You can do this by double-clicking the column border to auto-fit.

At the top of the sheet, leave a few rows for metadata: the week start date, location, or schedule period. This makes it easy to identify the schedule at a glance when printing.

Step 3: Enter shift times

In each cell where an employee is scheduled, enter their shift in a consistent format. Common formats include:

• 09:00–17:00 — time range (most readable)
• 8h AM — shift name with period
• OFF or leave the cell blank — for days off

Stick to one format throughout the entire schedule — inconsistency makes it hard to read and even harder to calculate hours automatically.

Step 4: Color-code your shifts

Color-coding makes the schedule far easier to read at a glance. A common approach is to assign one background color per shift type:

• Light green — morning shift
• Light blue — afternoon shift
• Orange — evening shift
• Light red — on-call or overnight

To apply fill color in Excel: select the cell(s), click the paint bucket icon in the Home ribbon, and choose your color. Add a color legend somewhere visible on the sheet.

Step 5: Add totals and formulas

If you entered shift times in the 09:00–17:00 format, you can use Excel's time functions to calculate hours automatically. Here's how:

1. Split each cell into start time and end time columns (or use separate columns from the start).
2. In a "Daily Hours" column, use: =TEXT(end-start,"h:mm") or simply =(end-start)*24 to get decimal hours.
3. In the "Total Hours" column (column I or J), use =SUM(B2:H2) for each employee row.
4. Add a footer row with =SUM(B2:B20) for each day to see total shift coverage per day.

Format your totals cells as Number (not Time) to avoid the common issue where Excel shows hours in hh:mm instead of a decimal number like 40.5.

Why use an online schedule maker instead?

Excel is powerful, but it has real limitations when it comes to scheduling:

• Manual color-coding is tedious. Every time a shift changes, you have to remember to update the cell fill color manually.
• No real-time sharing. Sending a .xlsx file via email leads to version confusion. Who has the latest copy?
• Formulas break easily. One accidental cell edit can corrupt your hour totals without you noticing.
• Not mobile-friendly. Excel schedules are hard to read and edit on a phone or tablet.
• No PDF export built in. Print layouts in Excel require careful page setup — margins, scaling, and orientation all need manual tweaking.

A dedicated online schedule maker handles all of this automatically. You get drag-and-drop shifts, automatic color-coding, instant PDF export, and nothing to install or maintain.

Frequently asked questions