Weekly timetable template also known as a weekly staff rota or a shift schedule template that helps to quickly produce your staff rota and save minimum two hours a week.
The template can also be used as multiple employee timesheet, by an employer, who needs to keep track of the worked hours for multiple employees and at the same time controll a payroll budget.
There are a few programs on the internet that can produce weekly staff time table automatically.
However , most of this staff rota or staff time table programs are either really expensive
or very complicated to use.
Spreadsheet123 has set up a weekly rota for you in Microsoft Excel. This weekly staff time table in excel is very easy to use and edit to meet requirements of your business.
The work time table template that we have created calculates the amount of hours for each staff member as for a shift as well as for entire week. The rota templates also calculates your
weekly labour cost and allowing you to create a simple weekly payroll budget.
Timetable template is equipped with HR dashboards that can help to organise your staff rotation and to control your weekly payroll
budget and salary distribution and also has an integrated time card template
in order to be printed for all of the employees individually.
What to think about when creating a staff timetable?
There is two main details that you must pay most of your attention when creating your weekly staff rota: your staff and your budget.
You can set up a fixed rota for a few weeks and rotate this every few months. Or have a fixed rota and move the shifts around.
The important and hardest thing is to work out the staff budget. How much can you spend on the labour cost? This is very important and it can be a guess at start.
This template can work hand to hand with our popular weekly payroll template and our weekly timesheet templates.

Screenshot 1
Screenshot 2
Screenshot 3
Screenshot 4
Screenshot 5
Screenshot 6
Full template preview on DocStoc
|
Excel timetable template can be a real help when creating weekly staff rota.
With few very simple settings this template can become a part of your staff management process and will
definitely save you tons of time.
With help of the integrated Timecard Template tool, your staff will always remember their shifts and you as a manager will always be provided with correct information of the overtime hours.
You can download and use or free time table template only for your personal use and with few limitations.
Read our Limitation of Use Policy that are applicable to both free and unlocked version of this timetable template.
If you need to download this template for commercial use to create your staff rota for your organisation, then you may need to purchase unlocked version of the time table spreadsheet, that
will also allow you to customize this spreadsheet to your company specific requirements.
You can also download Timetable (staff rota) Template that works in OpenOffice.org Calc.
|
>> Download Now
Version: ETT 1.0
File Type: .xls
Size: ~826.50 KB
Required:
Microsoft Excel® 2002(XP), 2003, 2007
Not Required:
Installation
Macros
Cost: $0.00
Free for personal use
License: View EULA
|
|
Buy unlocked version of Timetable Template risk free with 60 day full money-back guaranty!

Configure your browser to allow pop-ups before proceeding to payments screen.
Cost: $14.95USD Download will start after your payment is processed.
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.
|
How to use time table template?
1. Download and save your template on to your hard drive in your
preferred folder.
2. Open your time table template with MS Excel.
3. Open Settings worksheet and create a list of departments in your organisation.
4. On the same worksheet create a list of the days that will appear on your time table, assign code and assign paid hours as it is already shown on the template. For example
if your employee has a day off, your time table will display code OFF and employee gets paid for 0 hours or if you have a holidays your time table will be
displaying code H and you will get paid for 8 hours.
5. Open Employee List worksheet and create a list of your employees. Note that in free version list is limited to only 5 employees when
unlocked version of the template allows you to enter up to 30 employees.
a. ID column - you can only use numerical ID and should follow the sequence in acceding order.
b. Name column - enter name of the employee.
c. Contracted Hours - amount of hours that your employee has been
contracted to work.
d. Department - from the dropdown list choose the work department of your employee.
e. Rate - assign the hourly and public holidays payment rate. Note that payment for CH (Contracted Hours) will be calculated automatically.
6. Once all above steps have been completed, you can save your spreadsheet as template file (.xlt) on to your hard drive in your
preferred folder.
7. Open your saved time table template and go directly to the Time Table worksheet were you will see full list of your employees.
8. Enter week starting date, that is usually Monday and save your template under the same name as your week starting date to make this template easy to find when searching. (ex. 03-05-09.xls)
9. From the drop down list you can assign start and finishing time for all of your employees and for every day of the week.
10. Column Q shows the total amount of hours assign to each employee when column T
displaying the difference in between contracted hours and hours
displayed in column Q,
so that if you have assigned more hours to your employee than contracted this column will display the difference in cell coloured in red and if less than
contracted hours, the cell will still be displaying the difference but will turn blue. This will help to assign correct amount of hours to each of your employees.
Once all hours have been assigned you are ready to print your tome table. It can be printed on the standard A4 page.
11. In order for you to print timecard for all your employees you need to click on Time Card tab an click on the employee name in the list than simply click printer icon in your excel menu bar.
Repeat this step for each employee.
12. Open HR & Budget worksheet. In the Current Week Salary enter your weekly budget in the pink coloured cells. Scroll down to check your Daily
Attendance in all of the departments.
Once your budget is entered you can now view all your statistics on HR & Budget and HR Dashboards worksheets.
|
Links to other time table and rota templates and software
www.office.microsoft.com - Search Microsoft Office Online for more free Time Schedule Templates.
|
Share Our Time Table (Staff Rota) Template
If you have a web site, blog related to Excel, Business Software Recourses or you wish to suggest this weekly staff rota template to others, please link to
this page to spread the word about our free Time Table Template. Please copy and paste the HTML code below.
|