Timeclock project... going badly

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

No, unfortunately I am only comfortable with C++. VBA is new to me. I can kind of read it and see where it is going, and somewhat manipulate it (from what I know about C++), but it is hit or miss for me. I would still welcome any code, or ideas that you have though. Anything to get me started.


Thank you for your help
Jay

Jay

See if the attached file gives you any ideas. The sheet is protected, but there isn't any password, so you may want to expand that at least.

Select a date (you can prefill for your situation), then press the relevant button. If you aren't on a date, you are asked to select one. If the number has previously been completed, then it won't allow you to re-enter.


rylo

Rylo,
This is something that I would like to do as well. How would i go upon allowing that macro to paste the date and the time?

My dream would be to have a public file that users can have open and see when the users are online and when they click to punch out it saves it to a file so our supervisors can see what everyone is doing as a whole team.

Thanks
Nate