recording time in excel

[lrningxcel]

Hi, I m new to this forum, so I dnt really knw if this already exist in some thread. I tried searching some but have not been able to get to the solution.

Problem:
I need to record time in an excel sheet and I want to use computer's time for that. I want that time to be unaltered in future,even by human interference

For example: lets say workers enter a company at their scheduled time, and press CTRL+SHIFT+; evryday, excel would record their entry time for each day. However, if someone is late one day he can as well enter some other time just manually. Is there a way to restrict a cell to accept just the current time.

Thanks in advance

 

[etaf]

you could use a timestamp to do this
Create A Timestamp In Excel With Formulas
How to insert timestamps in excel sheet using formulas | Chandoo.org - Learn Microsoft Excel Online

but not sure how your spreadsheet is structured