Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Program email based or fill in program to manage time?

Sep 2, 2005 6:25AM PDT

I manage a small number of people who have flexible schedules but are still required to work a set number of hours. Unfortunately they sometimes "forget" to sign in when they arrive in the morning or "forget" to sign out when leaving. I would like a progam that could be on our network drive that they could electronically sign in and out and ideally could not be altered once entered. I need to keep a record of this so doing the email thing would be to volumnious. Is there anything available or perhaps something I could devise via Excel or anything? Thanks for any suggestions.

Discussion is locked

- Collapse -
Look to how it used to be done.
Sep 2, 2005 7:23AM PDT

A punch clock is still sold at Office Max and all over. It's easy to get people trained to use them since they only get paid for the time they are punched in for. If they forget to punch in or out, the simple policy of see the boss to sign off the manual entry re-enforces the training.

Cheers,

Bob

- Collapse -
I agree
Sep 2, 2005 10:34PM PDT

Where I worked for a large and busy office we had PC spreadsheets for people to sign in and out. It's difficult to control centrally so each employee had their own timesheet on their own workstation.

The only way to ensure correct completion was to have the supervisors check each spreadsheet regularly. In our case once a month. But it was, (and always will be), up to the individual to remember to sign in and out, and up to the supervisor to check for any discrepancies.

If you want a fool proof system, (if such is possible), you go for a mechanical clocking on and off system, and pay the employees for the time they register.

Mark

- Collapse -
It's amazing how
Sep 2, 2005 10:52PM PDT

quickly people learn or remember to do something when it involves money.

I use a "time sheet" created in Excel. It's set up for time in and out twice a day with formulas to add the hours worked. It wasn't difficult to create but, it doesn't solve the problem of people not clocking in or out.

- Collapse -
Nothing wrong with the old solution.
Sep 2, 2005 11:42PM PDT

But if you prefer it electronically, have a small form-based application programmed on your web-site. A shortcut to it in the Startup group will (totally or nearly) automatically take care of the logging in. Logging out remains there own responsibility!

If fact, any program run automatically from startup will do. But it needs to be able to access a central database, that's not accessable to any of the employees in any other way. A web-based solution seems to be a reasonable one.


Kees