Software Search, Categories and Specials
Ozgrid, Experts in Microsoft Excel Spreadsheets
Javascript DHTML Drop Down Menu Powered by dhtml-menu-builder.com

Active DataXL - Download

 

AnalyserXL - Download

 

DownloaderXL - Download

 

Smart VBA - Download

 

TraderXL - Download

Excel Timesheet

EXCEL VIDEO TUTORIALS / EXCEL DASHBOARD REPORTS

 

Excel Timesheet Will Keep Track of Your Employees Hours (up to 250)

Excel Timesheet

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

Excel Timesheet Template

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 or above.  Secure Payment Options

30 Day Money Back Guarantee and HUGE Discounts for Unlimited License

Excel Time Sheet Advanced (Open Source) $44.95 Excel 97 or above.  Password for VBA code and Formulae supplied.

Special ! Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $70.00. ALL purchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to special@ozgrid.com 31 days after purchase date.



Instant Download and Money Back Guarantee on Most Software

Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!

Microsoft and Microsoft Excel are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft

GIVE YOURSELF OR YOUR COMPANY 24/7 MICROSOFT EXCEL SUPPORT & QUESTIONS