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