TAH (Total Absence Hour) : Type the number of absence hour of absence employee.Format : HH:MM (Hour:Minute), example, come at 8 o’clock and break at 1 o’clock, you should type “8:00” and “13:00”.Before you start typing those time attendance, you can set the allocation absence time for one year period in the right table with absence allocation codes as its reference cells.I put some guidance on each header in comment boxes which will show up when you hover your mouse over those header.įollow the format below for typing in Time In/Out column In this timesheet, you can start to track your employee’s attendance by filling the Time In and Time Out column as well as their absence hour. Go to Employee Info worksheet and click on “edit timesheet” link to go to related employee timesheet or you can click on Time Sheet tab. There is an option to show or hide related employee hourly cost that you can select. Set timesheet parameter (starting date and report period).Click on “edit timesheet” link to go to related employee timesheet.There is a “Create Blank Timesheet” link in this worksheet which will bring you to the blank timesheet generator worksheet that you can customize, print and distribute to related employees to be manually filled before being inputted in this excel file. Leave the first two column, Employee Sheet and No columns, because this column will show employee’s timesheet links and no automatically. Go to Employee Info worksheet and put your employee’s ID, name, title, department, hired date, resign date, and their hourly rate for normal/regular hour, overtime and absence (if any). Type your country or company official holiday dates.Specify your company regular/normal working hour per day.
Select your company workdays in a week (in Lite version you can only choose Saturday and Sunday as additional workdays, while the Pro version will allow you to select/deselect any days in a week).Type your company attendance starting period.You can follow the short guidance below to start utilizing this template.
0 kommentar(er)
