Capturing Work Hours, Delineated by Catagory, Person, & Time Period

[Ned]

Hi, Currently a small group of individuals (~25) are
inputting their work hours into a shared Excel workbook.
The hours categories are a combination of ~15 ongoing
categories and an ever changing list of a couple dozen
small projects (we don't capture task hours within these
projects). As you would guess this methodology has proven
to be unwieldy and really lacking in reporting.
As a new user of Access I have trouble getting my mind
around three parameters to capture data, i.e. Hours by
(1) Work Category by (2) Person by (3) Time Period
(week). Hours by Person and Category seems to be easy
enough, but how do I delineate this data by time period?
Thank you, Ned

 

[Armen Stein]

Hi, Currently a small group of individuals (~25) are
inputting their work hours into a shared Excel workbook.
The hours categories are a combination of ~15 ongoing
categories and an ever changing list of a couple dozen
small projects (we don't capture task hours within these
projects). As you would guess this methodology has proven
to be unwieldy and really lacking in reporting.
As a new user of Access I have trouble getting my mind
around three parameters to capture data, i.e. Hours by
(1) Work Category by (2) Person by (3) Time Period
(week). Hours by Person and Category seems to be easy
enough, but how do I delineate this data by time period?
Thank you, Ned

Hi Ned,

Think of each chunk of time that someone works as a "time card record".
Each TimeCard has several pieces of information - Person, Category,
Date, NumberOfHours, Comment, etc. This allows people to put in each
chunk of time. I don't recommend that TimeCards be allowed to span
multiple dates (for example, time spent from Monday to Wednesday)
because it will be harder to report on date ranges in the future.
However, this approach means that your users will have to enter more
timecards.

The Person and Category are relationships to other tables that you can
maintain to make sure your TimeCards are consistent and valid.

For reporting, you can summarize the TimeCard records by Person,
Category, Date Range, etc.

Hope this helps,
--
Armen Stein
Access 2003 VBA Programmer's Reference
http://www.amazon.com/exec/obidos/ASIN/0764559036/jstreettech-20
J Street Technology, Inc.
Armen _@_ JStreetTech _._ com

 

[Jim Davenport]

Hi, Currently a small group of individuals (~25) are
inputting their work hours into a shared Excel workbook.
The hours categories are a combination of ~15 ongoing
categories and an ever changing list of a couple dozen
small projects (we don't capture task hours within these
projects). As you would guess this methodology has proven
to be unwieldy and really lacking in reporting.
As a new user of Access I have trouble getting my mind
around three parameters to capture data, i.e. Hours by
(1) Work Category by (2) Person by (3) Time Period
(week). Hours by Person and Category seems to be easy
enough, but how do I delineate this data by time period?
Thank you, Ned

Take a look at Timesheets at this site

http://www.webshipments.com

or try hotscripts.com