I figured out how to do both columns. i think i missed a step somewhere. I
closed out the worksheet and saved the changes. But when i opened it again it
didn't work. I looked on the screen where i typed the changes, the changes
was still there. but it didn't work. Itried to retype it. Nothing the cells
are still formatted hh:mm. But the clicking on the cell is gone. Any
suggestions? Thanks


"Mike H" wrote:

Hi,

It colud be done like this. Right click your sheet tab, view code and paste
this in on the right. Change the 5 (Column E) to the appropriate column. It
can be written so that this only happens in certain cells and if you need
more help post back.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column = 5 Then
If IsEmpty(Target) Then Target.Value = Time
End If
End Sub

Mike

"doss04" wrote:

I know the question has been asked and the simple answer is ctrl - shift - :
to add time in a cell. Unfortunatly sometimes the easy solution is still
difficult. I would like to know how to click on a cell and have the time
appear. Because i do security patrols and my laptop is mounted in my vehicle.
It"s difficult to type unless i stop to look at the keyboard and it's still
typing with one hand. If anyone is willing to tell that would be great. I am
new to excel and i am willing for trial and error. Thanks