You could lock these cells and protect the worksheet. Add buttons to enter the
current time into the appropriate cell via a macro (the macro would have to
unprotect the sheet, enter the current date and time, then protect the sheet
again).

On Sat, 10 Sep 2005 07:08:02 -0700, "Loriann"
wrote:

I would like to use the Excel template (from Microsoft site), "weekly time
sheet with breaks", for attendance in a small office/employees to log in
their time. I want them to only be able to enter current system time in the
"IN" and "OUT" cells (and not be able to manually type in another time), to
make sure cheating is not done on their time sheet. Is there a way to do
this?

"JE McGimpsey" wrote:

Ah, a completely different solution:

http://www.mcgimpsey.com/excel/timestamp.html


In article ,
"Major Tomm" wrote:

I guess I hosed this one up. Sorry about not being very clear, lets say
I
am on row 785, I have to add a date to E785 when I finish a project and
the
time that I finished needs to go into J785, I have been adding the time
in
manually, but I'd like it to happen as soon as I put the date into E785.
lets ignor the F column, I was trying to get the time column(J) closer
because J is too far right (off the screen).