Heart Beats since Birth Formula?

[Ken]

Excel 2000 ... Ok this one is for fun ... A co-workers
Birthday was today ... Question came up about how many
times his heart had beat since birth.

I created a formula using the NOW() function ... However,
cell value only updates if I SAVE or (F9) ... Is there a
way to write formula (or set calculation of cell) so value
in cell will change on the fly as the seconds pass away?

Thanks ... Kha ... (Another Long Week)

 

[Gord Dibben]

Ken

If you want Excel to do nothing else while you're watching the heartbeats
mount up, you could use an On-time VBA code to calculate every second.

Not too practical but doable. For more info and code see Chip Pearson's site.

http://www.cpearson.com/excel/ontime.htm

Gord Dibben Excel MVP

 

[Ken]

Gord ... (Hi)

Perhaps I didn't phrase my question correctly ... As the
seconds pass ... the Heartbeat value is constantly
updating (say Cell C3)... However, I can't watch it update
(like a running meter) ... I can only see it change when I
key (F9) to calculate & then Excel will give me the Heart
Beat Value at that point in time ... Is there a way to
setup formula, format, or calculate etc so I can watch the
value change as time passes (like a running meter) ...
Thanks ... Kha

 

[Scott]

Hi Ken,

One way:

Put something heavy on the F9 key.

Have fun!
Scott

 

[Gord Dibben]

Ken

You did phrase your question correctly.

I explained how to do this and gave you a website where you could find On-time
code to do it.

There is no formula or format that will show the heartbeat value change. Must
be VBA code.

While the code is running, you can do nothing else in Excel so, as I said, not
too practical.

The on-time code basically simulates you hitting the F9 key at intervals you
choose.

Gord Dibben Excel MVP

 

[Guest]

Gord ...

Yes ... I went to website you suggested & it does look
like this is the type of thing I would have to do ...
However, since I am not a Code Guy ... I guess this is
where I will end it ... Glad to see everyone has a sense
of humor ...

My many Thanks to those that support this board ... Kha

 

[Gord Dibben]

Ken

Good ending.

Even if you were a code guy, you would soon tire of a re-calc every second.

We get many requests here for "blinking" cells and all attempt to discourage
the idea.

Gord

 

[Scott]

Still, putting something heavy on the F9 key works, AND
its 'not-a-code-guy safe.'

Another code-free way that almost works is to query an
arbitrary data source with automatic refresh enabled. Too
bad the minimum time between queries is 1 minute. If it
were 1 second, we'd be in business.
Have a good weekend.
Scott