Difference between the time in and time out gives the number of hours worked for a specific customer. The table helps your employee in the time details in an hourly format i.e. Week Ending - once the week commencing date is entered the sheet automatically populates the ending dateįollowed by a table that has a horizontal breakage for the weekdays and a vertical breakage for the different customers along with the Time In - Time Out information for each.Week Commencing - date of the day which would be the first day of the week.Manager - manager name whom the employee reports to.Employee Email - mail communication can be easily setup.to be able to contact the employee if required Employee Name - enter the name of the employee.Employee ID - there is a unique ID that is linked to each employee.Department Name - stores the name of the department that the employee belongs to.

The first section publishes the company name, slogan, company address and logo along with the other basic details which are:

The second worksheet is the Weekly Timesheet which stores the Time In - Time Out information for different jobs, if an employee is working for multiple clients the time can be recorded for each client. You can choose the one that suits your company's logo or business stationary. Colour Scheme: is a design picker that can be used to change the colour of the timesheet.Company Address: here you can record the official address of the company with phone number, email, website address.You can choose to enable or disable these details in other worksheets Company Details: here you can record the Company name and slogan.The template has a 'Settings' sheet that has been divided into sections: To be able to track time while switching the jobs confirms that the basic regular hours are effectively accounted for. With its use, overall resource productivity is considerably improved and enhanced. This timesheet template helps you to organize time and set task priorities.

Calculate hours worked excel template