This extremely easy and simple to use Excel Time Sheet will keep track of your employees hours. It allows you to specify and set unpaid breaks in 5 minute intervals on a daily and employee basis.

The Timesheet can incorporate up to a 12 week period with any week and/or day being optional. All you do is enter your employee names once, save as a Template and you are set.

1.Enter your employee names in the cells below Employee Name on Week1 only. The same names will automatically flow through Weeks 2 to 12. Now save this file as a backup Template, File>Save As and Save as a Template.

2.Click the Set Weeks button on Week1 and specify how many weeks you will be using. If one of the Weeks only includes part of that Week, simply do not fill in times for those other dates. For example, if you wish to cover an entire month, set the Weeks to 5 then simply select the starting date from directly below Week 1 Includes and then only fill out times that correspond with the same month on Week5.

3.Select the starting date from directly below Week 1 Includes. 7 day periods will automatically flow through to all other "Week" sheets

4.Once you have done this, go to File>Save As and Save as a Template into the path that Excel defaults to.