The time card tab is a simple addition, which can help you to print individual time cards for all the employees, contains two time cards for two employees on the single page to save ink and paper, with separation line in the middle. The total time that you assign to each employee is displayed in the column ladled "Total Time" giving you a pretty clear indication of how many hours you have already assigned to the employee, the column next to the total time on the other hand, uses conditional formatting to highlight cell in blue or red to help you when you have missed out on something and also when you assign some extra time by accident. The process of assigning shift times consists in making simple selections of the shift start and end times from the drop-down, in which you also have option to select other pre-set days, such as days off work (OFF), public holidays (PH), holidays (H) and more, all depending on your requirements. ![]() The names of the employees are transferred automatically from the employee list including departments in which they work (the last is done purely for statistics, but we will cover this little later). All of the settings, as well as all other entries you are going to make will reflect here. ![]() The work shift schedule is basically the main worksheet where you'll be spending the most of your time than anywhere else on this template. As you might have guessed, this is the simple database that contains all basic information about employees, their contracted work hours, departments in which they are employed and their hourly rates. The name of the tab already suggests exactly what we are going to have to enter here. I will briefly go through all of the tabs, so that you can have a general idea of what you need to do and how to do it, you can also find more detailed information on the "Help" tab of the work shift schedule spreadsheet. You can begin by exploring the settings tab, where you can make most of the general settings, such as enter the departments relevant to your organization, select hourly format or select relevant payment settings for overtime and public holidays. The template is simple plug and play, which means you do not even need to make any changes, unless you prefer to customize it to your specific requirements. When you open the work shift schedule for the first time, you will notice that spreadsheet consists from several tabs that are all connected together using formulas and functions. View Screenshotīefore I dive into explaining of what's what, I need to mention that the trial version of the work shift schedule, which you can download free of charge is limited for use with only small number of employees, ten to be exact, but this is not going to restrict your abilities from fully testing this spreadsheet. ![]() Another change is in days of the week that do change their position in accordance with Week Commencing date entered. Besides, this modification introduces the slightly different approach, where you can set up different employment contracts with predefined contracted hours ( base hours) and then select a contract from the drop-down list on the Employee Register tab. View Screenshotīonus #2 Work Shift Schedule with Saturday/Sunday Hourly RatesĪnother modification of the original spreadsheet that allows to enter different hourly rates for employees who work on Saturdays and Sundays. The timecard follows the same principle, which makes easier for an employee to clock-in and clock-out when going for a break. Contains Fields for Logo & Company infoīonus Downloads Bonus #1 Work Shift Schedule with BreaksĪ modified version of the original Work Shift Schedule spreadsheet, except that this one allows for 30-minute breaks and the shift is split on before break and after break sections.Unlocked - so that you can customize it just a little more.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |