When it’s time to make the next employee schedule simply: Send it your employees when you’re ready.Save the schedule under any name you like (e.g.And Excel will calculate their pay for the schedule.You must enter it in this format: X minute break.

If you want to deduct an unpaid break from a shift, enter the break separated by a slash.If one of your staff is working 2 or more shifts in one day enter split shifts by entering the next shift separated by a slash /.You must enter shifts into the schedule in the format 9am-5pm.If you’d like to reduce the number of staff simply delete as many rows in the schedule as you’d like.If you’d like to schedule more than 20 staff, copy the whole last row and insert the copied cells below the last row as many times as needed.The default number of staff in the schedule is 20.To reduce the number of days you want to schedule for simply delete as many columns as you’d like.To add more days copy the whole last column and insert the copied cells to the right of the last column as many times as needed.

The default number of days you can schedule for is 8.

Select how many days you want to schedule for

The day of the week will change automatically depending on what start date you enterģ.

Enter the start date of your schedule in format mm/dd/yyyy.

Click “Enable editing” and “Enable content” as these prompts appear.

Download the file on your computer and open it.

Easily make changes to the work scheduleĬlick here to download the schedule How to make a schedule in Excel: 1.

The free and reusable Excel employee schedule attached below allows you to: There are a lot of employee scheduling apps out there to make the job easier, but if your employee schedule isn’t too complex or time-consuming Microsoft Excel can do the job fine. Scheduling your employees can be intimidating, especially if you have a lot of them. NovemShould you schedule your employees in Excel? Want to take a test drive without all the setup? Test drive our live demo

It's now even easier to set and manage employee availability with our new availability management solution.

Employee availability management made simple.

Know when drivers can work with availability management Know when employees are on site with geofenced clock-ins/outs Schedule by department, like housekeeping, concierge or maintenance. Handle last minute bookings anywhere, anytime with our mobile app. Teacher vacation or illness? See who’s available to cover last minute absences.Įnsure continuity of care with employee availability at your fingertips. Site-based schedules and maps ensure guards know where they're required.Įnsure staff arrive on time with shift reminders and notifications Schedule only qualified practitioners via certifications management.Ĭomply with local labor laws with in-built and custom rules. Keep employees refreshed by auto-allocating employee breaks.

Excel spreadsheet scheduling employees