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
