Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3032
  • Last Modified:

Excel VBA - Making a stopwatch (with milliseconds) that can show a running clock time

I have read a number of posts online relating to the making of a stopwatch in VBA.  I have been able to make the foundation of what i am looking for and i am now trying to tidy it up.
I am looking for suggestions of how i can make a cell show a running clock (the elapsed time).  The stopwatch will be used to time cyclists on a velodrome so they may do 40 or 50 laps (and there will be 4 or 5 riders at once on the track).  I will make a button for each rider which populates a specific column with split times.

Here is my code for the macro that adds a split time to the list.
Sub Athlete1Split()

ActiveSheet.Range("B58").End(xlUp).Offset(1, 0).Select

ActiveCell.Value = Format(Time, "hh:mm:ss:" & Right(Format(Timer, "#0.00"), 2))

End Sub
Stopwatch.xlsm
0
JohnNZExcel
Asked:
JohnNZExcel
  • 2
2 Solutions
 
suvmitraCommented:
You may consider looking at the sample file where you can see a running clock with elapsed time.
StopWatchEx.xls
0
 
dmitry_nCommented:
Do these runners share the same clock or do have individual counters?
0
 
JohnNZExcelAuthor Commented:
Good question.  I will make a single clock that will be used for all.  The start button will start the clock for all athletes but then individual buttons for each athlete will record the split times.
0
 
dmitry_nCommented:
Try http://www.xnotestopwath.com It also allows external IR sensor.
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now