Disregard last post. I figured it out. Thanks, you guys are really helping
make my job easier and more efficient.

"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