The Timetable template for Excel, is a simple weekly staff rota, which is a great time saver and helps to quickly produce a work shift schedule for your staff. The timetable can also be used as multiple employee timesheet, by an employer, that helps to keep track of the work hours for multiple employees and at the same time have a full control over the payroll budget.
There is a number of programs on the internet that can produce work shift schedules automatically, however, most of this programs are either really expensive or pretty complicated to use, when this timetable template is created for Excel, that most of us is already familiar with, is very easy to use and can be customized to meet requirements of your business.
The template automatically calculates the number of work hours for every employee individually as per each shift as well as hours for entire week, with inclusion of any overtime, paid holidays or public holidays, creates printable work shift timetable and at last, calculates weekly labor cost and allowing to create a simple weekly payroll budget distribution for every department. This spreadsheet has also been equipped with HR dashboards that graphically reflects all data generated by this spreadsheet.
Work Shift ScheduleFREE Version for Excel® & OpenOffice
NEW! Unlike previous version of the Timetable Template, this version lets you select either 12 or 24 hourly formats, when creating shift timetables.
The work shift schedule is designed to simplify a task of creating staff shift schedule and really meant for saving precious time, when doing so. Working with payroll budget simultaneously when preparing schedules, can help to allocate correct number of hours for every employee, without exceeding their contracted hours and, on the other hand your payroll budget.
Integrated attendance table, helps to control the number of employees on the shift in every department and along with HR & Budget table, also helps to allocate your payroll budget in between the different departments in your organization.
Printing work shift schedule and time cards.
Printing off the timetable is easy, since because the preselected printing area, won't allow printing of any unnecessary information. All information on the timetable is automatically transfered to the timecard, that can be printed off individually for every employee by simply selecting their names in the drop down menu and contains spaces for recording actual hours.
Both versions, free and unlocked are distributed under same License Agreement, with difference that the free version is restricted and works with only 5 employees.
by Alex Bejanishvili of Spreadsheet123.com
Work Shift Schedule ProProfessional Version ETT 1.1.1 for Excel & OpenOffice
The professional Work Shift Schedule is unlocked, works with up to 30 employees and can be customized with your company logo and generally can meet requirements of your business or organization.
Content of you purchase:
The .ZIP file contains both versions, for Microsoft Excel® and OpenOffice.org Calc, so that you can use version that is suitable for you most.
Note: Microsoft Excel® version will not work correctly if opened using OpenOffice.org Calc.
All of Spreadsheet123 trademarks, logos, links and copyright notices are outside of the printing area and won't be shown when you print your timetable or timecards.
Specification of the Commercial Version
- Can be customized with Logo & Company info
- Technical Support (for 90 days)
Microsoft Excel® 2002(XP) or Higher
(PC & Mac), OpenOffice.org Calc
Company Use EULA
Buy unlocked version of this Work Shift Schedule risk free with 90 day full money-back guaranty!
Configure your browser to allow pop-ups before proceeding to payments screen.
If for any reason you are not able to download this template after making a payment through PayPal, use our Contact Us form to contact us with your Paypal Transaction ID.
Disclaimer - The work shift schedule and information on this page is intended for educational an illustrative purposes only. Use information at your own risk. This spreadsheet is not intended to calculate any income related tax including but not limited tax allowances, off sick allowances, public holiday allowances as such.
How to use Work Shift Schedule
To begin using this template, either with Excel or Calc, first you'll need download an appropriate version of the shift schedule template.
Open your template and select Settings tab. Update preset department information with information relevant to your organization and simply delete all unnecessary data. If you will be using this template in the single department only, then you can delete all information and leave or add the name of the department, where you'll be using your timetable.
Here you can also change an information used for generalization of paid allowances such as sickness, public holiday, vocational allowances and add additional information in cells specifically provided for this. Remember that you only need to add or change the number of paid hours here that your company pays during staff holidays, public holidays or for sickness.
Update the list with your employee information, including their contracted hours, department information, hourly rate and public holiday rates (marked as PH), which could be different from regular hourly rates. The cell contracted hours (marked as CH) contains formula that multiplies employee regular hourly rate by a number of contracted hours and will be updated automatically. Once you've updated all information on your employee list tab, you are pretty much ready to start creating the shift schedule.
The timetable basically is a main tab that you'll be working on when creating the schedule of work hours for your staff. Most of the information on this worksheet, such as names, department name and contracted hours of your staff is automatically obtained from the employee list, so that you do not have to reenter everything again. Every column, staring from Monday contains 2 small columns to record a shift beginning and end times by selecting it from the drop down list, where you can also find the optional code, which you've created earlier on the settings tab to indicate OFF, PH, SICK or similar. You'll notice as you make changes that cells in the column marked Time will change the background color from blue, which indicates under timing to red, if more than contracted hours has been assigned to an employee (overtime hours).
Printing Time Cards
The next tab that's also used frequently is a Time Card that allows you to print an individual time cards for all your staff individually by simply selecting the name in the employee list. The time card acts as a simple timesheet that includes all shift hours given to the staff member and also contains an empty cells to record an actual "In" and "Out" hours.
Budget and HR Dashboard
If your company or organization includes more than just one department then the labor cost distribution already is a known phrase for you. The salary distribution in between the departments directly involves distribution of your payroll budget, which you can do by going to the HR & Budget tab. You'll notice that the background color of the column in which you have to enter your figures is pink. The amounts that you see in the column labeled Actual are calculated automatically, when you create the staff shift schedule and calculated as a sum of hourly rate multiplied by the number of hours assigned to every employee individually within the department. The difference between your budget and actual salary within the departments is shown in the column labeled Variance that displayed negative values in the cells where the actual salary is more than your budget, meaning bad, of course. Next to the salary budget columns, you will also find columns, which represent the breakdown of the actual salary, so that you can easily see the amounts paid to your staff for holidays, sickness, overtime, etc.
Daily Attendance table, displays the number of staff members in every department daily, which is intended to help you to see, if you have enough employees on the day.