PDA

View Full Version : [SOLVED] Stopwatch in Excel !!!!



whodafunk
09-28-2007, 01:45 AM
Hi fellow Excel users!

I?m trying to setup a stop watch in excel, where you can start the clock and be able to grab times and place them in different parts/cells in my excel document.

I'm trying to time how long it takes an object to pass a certain point on a course, and calculate the speed at which it slows down. I figure if a button transfers the time into a cell(s) as I click it, it will show the intervals between each point, and hopefully, show an increase in time as it gets slower.

Could anyone please help?

Thanks,

Whodafunk!!

johnske
09-28-2007, 02:30 AM
have a look here (http://vbaexpress.com/forum/showthread.php?t=14854&highlight=stopwatch)

Bob Phillips
09-28-2007, 07:00 AM
All you need is a simple macro attached to a button which updates the activecell




Sub InsertTime()
Activecell.Value = Now
End Sub


and format as time