Time Clock in Excel

  • Thread starter Thread starter LiseF
  • Start date Start date
L

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
 
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,"")
 
Back
Top