how to program a stopwatch using macros in Excel?

Question

Hi all

I'm seeing a video and recording the time when cars pass.

I need to record the hour, minute, second and hundredth (more precision would be fantastic) of those passings. I achieved how to record till seconds but not hundredth.

Does anybody know how to do it?

tx!

Answer 1

http://www.userfocus.co.uk/resources/datalogger.html

have fun! If this doesn't work email me and I'll write a little java program that will write to a file you can open with excel,

[e-mail]

Answer 2

There is a way to do it, but you'll also have to know how to get the macro set up to start the video.

Here's the code you can add to your macro to help out.


Dim StartTime as Double

'Set the start time at the point in the macro
'where you want to start the stopwatch
StartTime = Timer

'Set the messagebox to display when you
'want the stopwatch to stop.
MsgBox Format(Time - StartTime, "00.00") & " seconds"