System clock start/end button.

[Jaloko]

So, I know how to make a simple time Variance between times entered manually.

But what I want to do is have a button that you can click and it will grab the time from your System clock, record that in a cell. I suppose I will do the same with the end time as well. I then want to have it record the variance between those 2 times.

I know to do this manually by entering the time but I want to make it easier by simply having it pull the time directly from the system clock using a start button and end button.

 

[Jeffrey Mahoney]

Make two ActiveX buttons (Developer Tab - Insert - Command Button ActiveX control)
Right click on each and choose properties. Change the Name and the caption for each.
Double click on each button with Designer Mode on
Add the following code just like I did:

Private Sub StartTime_Click()  
Range("I3") = Now() - Int(Now())
  Range("I4") = Now() - Int(Now())
  
End Sub


Private Sub EndTime_Click()
  Range("I4") = Now() - Int(Now())
End Sub

Turn Designer mode off
In Cel I5 put: =I4-I3
Format cells I3:I5 with this format: h:mm:ss;@

The start button adds the current time to both the Start Time and End Time Cells. The End Time Button puts the current time in the End Time Cell

 

[AlphaFrog]

Private Sub StartTime_Click()  
Range("I3") = Now() - Int(Now())
  Range("I4") = Now() - Int(Now())
  
End Sub


Private Sub EndTime_Click()
  Range("I4") = Now() - Int(Now())
End Sub

You could replace ...
= Now() - Int(Now())

With...
= Now - Date

Or this...
= Time

 

[Jeffrey Mahoney]

Habits

Good call Alpha