doremon313
New Member
- Joined
- Jan 22, 2010
- Messages
- 3
Hi All
I am looking to create a excel time clock so that employees and clock in and out of work and break, so I know you can press ctrl+shift+; to enter current time but I am not sure how to record that as a macro.
I also try using the now() function and have a macro copy and paste only the value, but I am not sure how to tell it to paste it on the next available cell.
Has anyone done something similar that can tell me a workable solution? thanks!!
I am looking to create a excel time clock so that employees and clock in and out of work and break, so I know you can press ctrl+shift+; to enter current time but I am not sure how to record that as a macro.
I also try using the now() function and have a macro copy and paste only the value, but I am not sure how to tell it to paste it on the next available cell.
Has anyone done something similar that can tell me a workable solution? thanks!!