Time Clock in Excel

[LiseF]

I would like to be able to click on a cell then click on a clock to enter my
start and end times, i.e.
start time: click in a cell, then on clock icon or button: 9:00 AM,
end time: click in a cell, then on clock icon or button: 10:00 AM
time worked: click in a cell to get the tme worked: 1:00

 

[Gary''s Student]

Excel has a built-in time clock. Click on a cell and touch CNTRL-SHFT-;

 

[LiseF]

I already know this....I would like to have an actual clock as I asked in my
question.

 

[Luke M]

You could make a button (from the forms menu) link to this macro:

Sub TimeStamp()
ActiveCell.Value = Format(Now, "h:mm AM/PM")
End Sub

For the last cell, that would be a simple formula, no need to click
anything. Something like:
=IF(COUNT(A2:A3)=2,A3-A2,"")

 

[Gary''s Student]

In that case,see:

http://www.dailydoseofexcel.com/archives/2007/08/03/time-picker/