time entery to the cell

[Guest]

any one can help me how to make the cell automatically take from the time of the computer... because i am using the timesheet tha can download from office online but the problem isour staff are key-in the correct time for there time in or time out... what i want is no need for them to enter the time, they just click the time in or time cell the time of the computer will be recorded to the cell....

Thanks a lot to all the expert that very helpfull.....

jeff

 

[Frank Kabel]

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

for entering a timestamp automatically then a cell changes