Time Sheet Advanced Open Source

With this version the password for the Worksheets and the VBA code is supplied. This extremely easy and simple to use Excel Time Sheet will keep track of your employees hours.

Description of Time Sheet Advanced Open Source:

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.

See Also: All products from OzGrid Business Applications

1. Project Management 1.0
   The Project Planning and Management template is designed as a generic solution to plan and manage any project.
2. Excel VBA Models Combo Set
   Are you having difficulty understanding how to do option pricing modesl and numerical procedures within Excel? Do you want to see practical examples? The The Excel VBA Models Combo Set solves these problems.
3. OM-FACILITY LOCATION
   Excel Spreadsheet Templates for locating distribution center.
4. Advanced Data Grid Control - Professional License
   This java Data Grid Control applet enables the display of data in rows and columns in java & web applications. Powerful features include Fast Sorting, Data Acquisition, URL Hyperlinks, Embedded Images, Column Totalling and much more.
5. ExcelExplorer 1.01
   ExcelExplorer is a new utility for quick and easy managing excel files. Using ExcelExplorer you can view, move, delete or rename excel files even without Excel on your pc. ExcelExplorer has transparent interface of two panels.
6. Excel Level 1, 2 and 3 Training
   MS Excel Training for newsletter members only
7. OM-ACCEPTSA
   Excel Spreadsheet Templates for Quality Control, Acceptance sampling.
8. 33 Nuevas Funciones Excel
   33 Nuevas Funciones Excel Este complemento (add-in) agrega 33 nuevas funciones a la Hoja de Calculos Excel. Incluye la funcion ALETRAS, que convierte un numero en letras (por ej. 132 > Ciento treinta y dos).
9. Report Runner for Microsoft Excel
   Print (or export) your Excel reports automatically in the order you need them.
10. Microsoft Excel Tool Kit for Microsoft Excel
    Get the most popular time saving add-in for Microsoft Excel and two downloadable books on Excel macros in one great collection.
11. Illustrix Dream Pack 1.0
    Absolutist introduces the new genre mix! It's not just another Tetris(tm) clone with puzzle elements - arcade-style gameplay is combined here with the mystique of the puzzle.
12. WaveMaker MP3 to WAV Converter 2.3
    WaveMaker MP3 to WAV Converter is a easy-to-use yet powerful audio software that lets you convert files in MP3 format into CD quality standard PCM wave (.WAV) digital audio files.
13. Web SCUBA Log
    Share your log book through the Internet. This Internet based SCUBA log will help you organizing dive logs just like what you did to ordinary traditional paper log book. Automatic calculation of bottom time for every dive.
14. 3D Halloween Screensaver
    A beautiful 3D Halloween Screensaver that will have you in awe as you witness what actually goes on during the midnight hours at the graveyard.
15. WorkWeek
    Keeps track of your work schedule and hours. Holds name, date, starting time, ending time, hours, and note. There's another screen where you can list the schedule by date and filter by name.
16. Redirect Boss
    Create Instant Redirection Scripts Easily Create Domain-Name Based Redirect Scripts No Programming Knowledge Required Multiple Domains - One Hosting Account Perfect for Mini-Sites Full Royalty Free Resale...
17. Web Photo Gallery 1.0.0
    Internet web based photo gallery. Share your photo online. Auto generate thumbnail, you do not have to resize the pictures to be uploaded. Auto embed copyright notice or watermark. Also protected from mouse right click.
18. Traffic Jam Extreme
    Welcome to Traffic Jam Extreme ordering page! What you should know about ordering Alawar games: After ordering to gain access to all the levels and other game features.
19. Banner Buddy
    Use Banner Buddy To Quickly Generate Banner/Text Link HTML! With a few mouse clicks, you can turn text and graphics into "clickable" links to your web site. HIDE affiliate links while visitors do "mouseovers". Also creates text under the banner.
20. Dekart SIM Manager 1.08
    With SIM Manager, you can easily create, edit, and backup phonebook entries using your PC and stop typing in information using the mobile phone's keypad.