I am trying to create an Excel spreadsheet that I can use as a time clock for my employees. Currently they just put their times in manually, and there really is no way for me to verify if they are being truthful or not.

I am trying to make a spreadsheet that will only have 4 columns (Date, Time In, Time Out, and Total). I would like for the employee to just be able to click on a certain cell (clock-in or clock-out), and have the spreadsheet fill out the appropriate space with the current time.

So here is my problem. I am trying to use the following function =HOUR(NOW())& ":" &MINUTE(NOW()) within the 'button' cell, and have the receiving cell equal it. But it seems that whenever I call the 'NOW()' function, all of my cells that are referencing it update, and I am not sure how to make only that one cell update.

Does anyone have any ideas?

Thank you for all of your help
Jay