|
|
|
Main
> Business
& Finance >
Spread Sheets
> Time Sheet Advanced Upgrade to 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. 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.
|
|
Buy
Now |
|
Time
Sheet Advanced Upgrade to Open Source screenshot:
|
|
|
Product
Information
|
-
Version:-
-
Price:
$44.95
-
Size:
MB
-
License:
Shareware
-
Developer:
Dave Hawley
-
OS:
Windows
-
Rating:
|
|
|
|
