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
