counting seconds

[scott]

=SECOND(NOW()) and holding down the F9 key starts at
whatever the second hand is pointing at and counts up to
59, then starts back at 0, 1, 2, to 59, 0, 1, 2 and so
on. How can I write it so it starts at 0, and counts 1,
2, 3,...,59, 60,61,...forever?

 

[Frank Kabel]

Hi
have a look at
http://www.mvps.org/dmcritchie/excel/datetime.htm
(at the bottom of this site): There are some example counters / stop
timer functions. This may what you're looking for

 

[scott]

Frank, your message is not available to me for some
unknown reason.

Anyways, I figured it out on my own. Start with A1 empty,
in B1 put =IF(A1="","",IF(B1<>"",B1,ROUND(NOW()
*24*60*60,0))) and in C1 put =ROUND(NOW()*24*60*60,0)-B1

When you're ready to start, enter something in A1, push
enter, and tape F9 down until you're done. To start over,
uptape F9, clear A1, and push enter, then put something
back into A1 as before.

 

[scott]

Frank,
Thanks for the reply. When I checked it Friday, all I
got was "message unavailable." So I posted that I had
figured it out on my own in the mean time, but it looks
like that didn't go through either. Here's how I did it.
In A1, put nothing yet.
In B1, put =IF(A1="","",IF(B1<>"",B1,ROUND(NOW()
*24*60*60,0)))
In C1, put =ROUND(NOW()*24*60*60,0)-B1
Now, when you're ready to start, enter something in A1,
and tape down the F9 key. When you want to stop, release
F9. To start over, clear A1 first, then fill it and tape
F9 as before. The link you provided has a nice example,
but this one works without code. I guess the tape is the
code substitute.
scott