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 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.
1Enter your employee names in the cells below Employee Name. The same names will automatically flow through to Weeks 2 to 12.
2 Select the starting date from directly below Week 1 Includes. 7 day periods will automatically flow through to Weeks 2 to 12.
3 If any weeks are not needed, simply ignore them and do not enter any times on them. You can hide these Sheets via Format>Sheet>Hide. If one the period only includes part one Week, simply do not fill in times for those other dates. For example, if you wish to cover an entire month, simply select the starting date from directly below Week 1 Includes and then only fill out times that include the same month on Week5.
4 Once you have done this, go to File>Save As and Save as a Template into the path that Excel defaults to. Next period, simply pull up the Time-Sheet Template again.
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.
