The process of tracking time is unique to every employee or position, so
there’s no one-size fits-all sheet that will do the job. Still, certain
principles and features will generally play into most timesheet models.
For instance, before you start formatting cells and entering formulas,
you need to decide why you’re tracking time, who’s going to use that
information, and how:
- Decide on a time period. (Management will probably make this
decision for you.) Most of us track hours weekly, biweekly, or monthly.
- Tracking
just time isn’t always enough. Many companies bill your hours back to
clients. Therefore, you must allocate your time to specific projects.
This article will show you how to create a weekly timesheet you can
easily adjust to track biweekly and monthly times and projects. As is,
this sheet doesn’t document breaks or allow for flexibility in
scheduling. However, the basic structure and formulas are present, so
you can easily customize the sheet to fit your needs.
This article will show you how to create a weekly timesheet you
can easily adjust to track biweekly and monthly times and projects. As
is, this sheet doesn’t document breaks or allow for flexibility in
scheduling. However, the basic structure and formulas are present, so
you can easily customize the sheet to fit your needs.
Read more:
http://opencast-labs.com/downloads/How_to_Build_a_simple_timesheet_in_Excel.pdf and the sample files here http://opencast-labs.com/downloads/TimeSheetExcel.xls
Adopted from TechRepublic
