This extremely easy and simple to use Excel Timesheet will keep track of your employees hours (up to 250). It allows you to specify and set unpaid breaks in 5 minute intervals on a daily and employee basis. The Timesheet incorporates a 1 to 12 week period with any week and/or day being optional.
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 hour period in 5 minute intervals, all you do is select a Start time and an End time from a drop down list. This makes it impossible to enter times that Excel wont recognize.
The Timesheet 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.
Enter your employee names in the cells below Employee Name on Week1 only. The same names will automatically flow through Weeks 2 to 12. Now save this file as a backup Template, File>Save As and Save as a Template.
Click the Set Weeks button on Week1 and specify how many weeks you will be using. If one of the Weeks only includes part of that Week, simply do not fill in times for those other dates. For example, if you wish to cover an entire month, set the Weeks to 5 then simply select the starting date from directly below Week 1 Includes and then only fill out times that correspond with the same month on Week5.
Select the starting date from directly below Week 1 Includes. 7 day periods will automatically flow through to all other "Week" sheets
Once you have done this, go to File>Save As and Save as a Template into the path that Excel defaults to.
You can now add the Time Sheet to any Workbook by right clicking on any Worksheet Name tab and selecting Insert and choosing Time-Sheet.xlt from the General page. You can also add the Time Sheet as a Template Workbook by simply going to File>New
Timesheet Summary Page > Set Weeks > Timesheet Printing > Copy All Times to Next Week > Sort A-Z and Sort Z-A > Delete Name(s)
Excel Time Sheet Advanced $29.95 Excel 97 through to 2003 Payment Problems/Options
30 Day Money Back Guarantee and HUGE Discounts for Unlimited License
Excel Time Sheet Advanced (Open Source) $44.95 Excel 97 through to 2003 password for VBA code and Formulae supplied.