Time Sheet Advanced Open Source is an esay-to-use Excel Time Sheet that can keep track of your employees hours.It is very useful for people who are engaged in business & fancial oppucation. This version is perfected with the password for the Worksheets and the VBA code. With this version, you can specify and set unpaid breaks in 5 minutes intervals on a daily and employee basis. If your employees work hours that span into a new day, the time calulations will accommodate it. For employees whose working time span a 24 hours period in 15 minute intervals. What you need to do is only to select a Start time and End time from a drop down list and this makes it impossible to enter times that Excel won' recognize.
Up to a 12 week period with any week and/or day are included in Time Sheet Advanced Open Source for your option and 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 directly from 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 conceal 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.