I have a employee time sheet and let employees punch in/out by pressing
Ctrl+Shift+;. This works fine but occasionally they punch in wrong time by
manually typing in/out. Now I am unsing =NOW() with data validation. Only
down side is employees have to press F9 to get a current time. Is there any
function that will re-calcualte automatically. I am very new to excel 2007.
I am not familiar with creating a macro. Please help. Thanks.