Holidays and Weekends are self-explanatory. Order of priority for colors: Not Applicable > Not Employed > Holidays > Weekends > leave types In addition to the 5 leave types, we also have display for the following: Holidays (purple), Weekends (Dark Gray), Not Employed (Dot pattern) and Not Applicable (Diagonal Line pattern). The legend is shown at the top indicating what each color means. Leave Tracker Dashboard – showing calendar for all employeesĪs you can see from the above screenshot, the leave types are shown in different color. Though Saturday/Sunday is the most common weekend choice, there are so many countries that use a different work week and weekend setup. I learnt from our readers that weekend days can vary a lot by country. In order to calculate attendance of employees automatically, we need to know company weekends so that we can remove them from working days. You can create a leave type and enter 0.25 as ‘Day Value’. If your company allows 2 hours leave in an 8 hour workday setup, that would be 0.25 day. That means that when an employee takes Half Day leave, template will add 0.5 to leave taken total and reduces the Worked days by 0.5. For example, I have entered 0.5 for ‘Half Day’ leave type.
This setting is present to handle partial days of leave. You can see that there is an option to assign ‘Day Value’ to each leave type. You can just type over these names and replace with your own preferred names. Automated Annual Employee attendance reportĮnter 5 types of Employee Leave types to suit your businessīy default, you will see the leave types (Vacation, Sick, Unpaid, Half Day, Other).Fully Automated Vacation Tracker Dashboard with monthly calendar view.Can use the template continuously for many years (keep all your data organized in one file :)).Easy to customize colors to suit your preferences.Easy to enter Leave in ranges of dates (example: 4 days of leave from Nov 21st to Nov 24th).Employees can have start dates and termination dates.Customize which days are weekends (not working days).Customize settings to meet your business needs.Step 2: Configure the Settings information.How to Use Employee Leave vacation tracker in Google Sheets.
0 kommentar(er)
