VBA Code Help
 

Hi Guys,

Below is some code to start a stopwatch and run in Mins & Seconds I
would also like it to include hours as well.

Public Sub startClock()

Dim start
Range("F6").Select
start = Timer

Do While stopped = False
DoEvents
Worksheets("Stopw").Range("F4").Value = Int((Timer - start +
0.5) / 60)
Worksheets("Stopw").Range("H4").Value = (Timer - start) Mod 60
Worksheets("Stopw").Range("I4").Value = (Timer - start + 0.5) -
(Int(Timer - start + 0.5))
Loop

End Sub


--
Runner77
------------------------------------------------------------------------
Runner77's Profile: http://www.excelforum.com/member.php...o&userid=30388
View this thread: http://www.excelforum.com/showthread...hreadid=507113

VBA Code Help
 

Hi Runner77,
Try...

Worksheets("Stopw").Range("D4").Value = Int((Timer - start + 0.5) /
3600)
for hour in D4 since there are 3600 sec per hour.

Ken Johnson