Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Option Explicit
Private Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long) Private Declare Function timeGetTime Lib "winmm.dll" () As Long Sub Test() Dim lStartTime As Long Randomize Sleep (Int((10 * Rnd) + 1) * 1000) lStartTime = timeGetTime() MsgBox "Press the Enter key as fast as you can", , _ "reaction speed tester" MsgBox "reactiom time: " & timeGetTime() - lStartTime & " milli-seconds", , _ "reaction speed tester" End Sub RBS "David94" wrote in message ... I am doing a science fair project which involves human reaction times. Can I set Excel up to measure and record the time between two inputs (keystrokes, mouse clicks, etc...). Does Excel have a "stopwatch" function? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
In an Excel formula can the clock be used to measure time? | Excel Programming | |||
How to measure time for processing periods? | Excel Discussion (Misc queries) | |||
measure calculation time for multiplication of two matrices | Excel Worksheet Functions | |||
Want to measure macro elapsed time. | Excel Discussion (Misc queries) | |||
Proc to measure time intervals | Excel Programming |