Web Development

Ask something
Discussion Locked

Tracking Hours Worked on Projects

0 helpful
2 replies

by shanghai sam

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I would like to set up an Access 97 file which automatically keeps track of our employees and the time spent on each project, every day. It should also calculate a total for the day, and a total at the end of the month.

Each employee works on different projects, and the time for each project needs to be tracked as well.

Also, I need a field for "Completes", "Partials", and "Refusals." These fields would be populated with single- or double-digit integers, and also need to be added up each day, each month, and for each project.

Can anyone help me with this or point me into the right direction of where I can find a sample?

Thanks a bunch,
ingrid
beach@nauticom.net

2 replies

by timthetoolman

Hi Ingrid,

You could download and check out software from...

http://piau.tucows.com/business/project95.html
(remove spaces from the above URL)

There are lots of free/shareware and demo time management utilities downloadable from there.

I'm sure one at least will give you an idea of what kind of system you could put together. Or perhaps you could even use one to do what you want!

Probably it wouldn't use access 97 though and its even less likely that you could get to the internals of it to redesign it for yourself.

...but database and system design specifics are probably a little out of the scope of this forum. Still.... you may be lucky and have someone answer whose willing to spend the considerable time helping you withthe design.

Good luck,
Cheers,
Tim.

by parkin_thom

If you download http://parkint.home.mindspring.com/thomware/index.html#svctimer
you will have a great little piece of FREEware that;
Is a timer
Can be run in several instances (for those times you are working on more than one project at a time)
Allows you to input a Client name or project name
Can be paused and restarted
Ultimately, when stopped, will place a 'record' of the accumulated time on the Windows clipboard to be pasted into ANY application.
So, use a spreadsheet, database, document, or whatever and simply paste the results of each project; as it is completed into the form.

The application is free and was written by a magnificently talented and incredibly humble coder.

This discussion is closed to new replies.