Employee schedule template for Excel

By Al Davies ยท Updated November 15, 2026

Short answer: Make one sheet with a name column, seven day columns, and an hours column, then use a formula to turn start and end times into hours. The layout and formulas are below, ready to type in.

What columns does the sheet need?

ColumnHoldsExample
ANameJo
B to HShift for Mon to Sun9:00-17:00
ITotal hours=SUM(J2:P2)
J to PHours per day (helper)8
QNotesOff Friday

Keep the helper columns to the right so the printed part stays clean.

How do you turn times into hours?

Excel stores a time as part of a day, so subtract the start from the end and multiply by 24. On a scratch sheet, put the start time in A2 and the end time in B2, then type this in C2:

=(B2-A2)*24
Shift 9:00 to 17:30 gives 8.5
Overnight shift: =(B2-A2+(B2<A2))*24

A blank layout to copy

Week of ______
Name | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Hours
_____ | | | | | | | |
_____ | | | | | | | |
_____ | | | | | | | |
Staff on shift | | | | | | |

How do you count staff on each day?

Add a bottom row that counts filled cells. In row 8, under the Monday column, type =COUNTA(B2:B7). Copy it across to Sunday. A day with a count of 1 may be a gap.

What does a sheet not do for you?

A sheet does not know who is allowed to work. Before you fill a cell, check the person's availability. The page on scheduling outside availability gives the question to ask.

It also does not tell you about a person who gets no shifts. Our page on leaving someone off the schedule explains why that matters.

When should you move off the sheet?

A sheet is fine while one person edits it. When three people ask for changes by text, the sheet falls behind, and a shared schedule works better. Print the week by role with your events and a QR code. Printing also posts it to your team. For time off, staff ask in three steps. You approve or deny in one place.

If you work in Google Sheets instead, the same layout works. The Google Sheets version uses the same steps.

FAQ

How do I build a staff schedule in Excel?

Set up a name column, seven day columns and an hours column. Enter the shifts, then add hours with a formula.

What is the formula for hours between two times?

Subtract the start from the end and multiply by 24, like =(B2-A2)*24.

How do I handle an overnight shift?

Add a check for an end time that is smaller than the start time, as in the formula shown above.

Can I use the same layout in Google Sheets?

Yes. The columns and formulas work the same way.

Sources

Try ShiftGarden to put your week on one page.