|
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.
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 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
Time Sheet Advanced Features:
- Copy All Times to Next
Week
- Sort A-Z and Sort Z-A
- Delete Name(s)
- Timesheet Summary Page
- Set Weeks
- Timesheet Printing
|
