Microsoft Excel - I want a VBA formula for time tracker..which will record each activity start time&endtime;

I want a VBA formula for time tracker..which will record each activity start time&endtime.

When we click the start button the start time will come as well as our employee Id will appear on another column, in another column task list will appear.  when we click end button the end time will come.

We cannot click start button twice until end button is clicked.

Hello Ranjan,
I would probably use two Option Buttons.  One labelled Start and the other labelled Stop.
Code for the Start button
Private Sub OptionButton1_Click()
If OptionButton1.Value = True Then Range("D3").Value = Now()
plus gather/show the other data that you want
End Sub
Code for the Stop button
Private Sub OptionButton2_Click()
If OptionButton2.Value = True Then Range("D4").Value = Now()
End Sub

Hope this helps.  let me know if you need more.
Regards
Harry