Upgrade to Advanced Excel Timesheet

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. If your employees work hours that span into a new day, no problem, the time calculations will accommodate this. All Start and End times span a 24 hours period in 15 minute intervals, all you do is select a Start time and End time from a drop down list. This makes it impossible to enter times that Excel wont recognize.

The Time Sheet incorporates a 1, 2, 3 or 4 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. The same names will automatically flow through to Week2, Week3 and Week4.

2 Select the starting date from directly below Week 1 Includes. 7 day periods will automatically flow through to Week2, Week3 and Week4.

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

4 If Week2, Week3 or Week4 are not needed, simply ignore them and do not enter any times on them.

5 You can now add the Time Sheet as a Template Workbook simply by going to File>New

The Totals sheet has a very easy to use Pivot Table which is based off all employees and their hours. You can simply specify to display results by Week and/or by Name or show All Names and/or All Weeks. Double clicking on any hours within the Total Hours field will give you a Break Down of the displayed data