The various time categories are regular hours, overtime, sick, vacation, public holidays, etc. The table gives the day wise details of hours spent. Week Commencing - date of the day which would be the first day of commencing the work.

Manager - manager name whom the employee reports to.Employee Email - records the email ID for setting up mail communication.to be able to contact the employee if required Employee Name - enter the name of the employee.Employee ID - is a unique ID linked to each employee.Department Name - stores the name of the department that the employee belongs to.Other important information captured is as follows: Both timesheets print the company details and the logo, which you can insert. The time is stored in a decimal format like a two hour thirty minutes of work would be entered as 2.50. The Weekly and bi-weekly Timesheets are almost same with a simple difference that one records the time week by week and the other maintains the time record for two weeks. You can even set the color scheme for this timesheet. This template helps in calculating total amount of hours and employee gross wages on weekly or bi-weekly basis. There is another field to record the currency symbol from the drop down. You can select enable or disable option from the drop down menu to either print the company name or slogan onto the timesheet or not. The settings page in this template acts like a database to store all the company details that would automatically populate some cells on the weekly and bi-weekly sheets. Spreadsheet123 offers a template that generates both weekly and bi-weekly timesheets.

Hourly invoice templete microsoft excel