Bundy clock

[Oyster1967]

HI guys,
I want to be able to calculate the time a student comes into a room to study and the time they leave.
I am using the =now() on entry thats fine..BUT when I put =now() when they exit it changes the entry time to the same.
what can I do?


Yun Mi Sun 9/03/2012 13:26 9/03/2012 13:26

 

[AlphaFrog]

Instead of entering =Now(), select the cell and then Ctrl+Shift+SemiColon. That will put the current time in the cell and it wont change afterwards.

Keyboard shortcuts you can use to insert the current time and date.

Current date: Press CTRL+SEMICOLON

Current time: Press CTRL+SHIFT+ SEMICOLON

Current date and time: Press CTRL+ SEMICOLON then SPACE then CTRL+SHIFT+ SEMICOLON


Or you could assign a macro to any Keyboard shortcut you want.

Sub Currently()
    ActiveCell.Value = Now
End Sub

 

[Oyster1967]

Thanks mate, thats great. Do you know, just out of curiosty, why the =now() cell effects the other one though?

 

[AlphaFrog]

The =NOW() is a volatile formula. When the worksheet recalculates (triggered by a new formula entry), the NOW formula will update its' result.