running clock in a cell A1

  • Thread starter Thread starter Ted
  • Start date Start date
T

Ted

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.
 
This could be a very simple with a macro.
Here's a one line macro that puts in the date/time but doesn't use a
formula (assuming that you know which cell it is going into):

Sub TimeNow()
Range("B10") = now()
End Sub

You could also add a button (from Insert ribbon) that they could click
to run the macro.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

running clock in a cell 1
Daily Time Sheets with Rounding 1
TIME SHEET FORMULA CONDITIONS" ARE THEY POSSIBLE" 1
running clock 4
Locating duplicates within range of time punch data 2
Time clock, punch in/out 5
Make a cell not equal less than a certain number 5
Averaging Time 10

Back
Top