Can I use Excel to measure time?

D

David94

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?
 
F

FSt1

hi
excel doesn't have a built in "stopwatch" but a number of people have wanted
such.
see this site.
http://www.mvps.org/dmcritchie/excel/datetime.htm
all about time and dates, how to calculate, measure, extract, ect.
this is a large site but down towards the bottom is a "timer". not sure if
you can use it but it might give you ideas.

Regards
FSt1
 
R

RB Smissaert

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
 
Top