Hi,

I need some guidance . I'm not too bad with excel but I'm no expert either. I have created a time sheet and I would like to know if there is a way to. As of right now I have employees enter the time by using Shift+Ctrl+;, so the exact time is recorded, however employees can write in whatever time they want. so I guess what I want to do is 2 things:

1- can the cell be formatted to only accept Shift+Ctrl+;, so that the exact time is entered in the cell and prevent employees from entering times they were not at work? and
2- can the cell auto-lock after Shift+Ctrl+; is entered so that they can't modify the time sheet the next day if they arrived earlier than the day before?

I'm not sure if what I want to accomplish is doable.. please help and remember I’m no expert Below is the document i created. Thank you!!!
Timesheet.Test.xlsx