recalculate.now() macro

[bharwood]

Hi. I have a very simple sheet (within a larger workbook) with a series of timers on it that compares two dates/times and then calculates the result. The timers show elapsed time in days, hours, minutes and seconds. I'm looking for a simple macro that will make the timers "run" by recalculating the sheet (or range of cells) continuousy until it is halted. The macro I'm using is embarrassingly simple:

Mission Control Clock Macro

=CALCULATE.NOW()

=GOTO(A2)

=RETURN

<colgroup><col></colgroup><tbody>
</tbody>

It works, but it can take more than one second to complete a cycle, so the timers do not run smoothly. I realize this is probably trivial to most of you, but I'm not a macro guy and I would surely appreciate some suggestions to make this work faster. Thanks.

 

[AvcGJS]

I suspect a second+ is the length of time that excel needs to calculate/run the code/get the time from the server.
Excel may not be the ideal tool for this, although if you have the value of 1 second in another cell (lets say C3) the you can compensate by adding the second lost calculating back onto the time?

 

[bharwood]

I suspect a second+ is the length of time that excel needs to calculate/run the code/get the time from the server.
Excel may not be the ideal tool for this, although if you have the value of 1 second in another cell (lets say C3) the you can compensate by adding the second lost calculating back onto the time?

Not sure what you mean by "get the time from the server." The worksheet simply subtracts one date/time from another and displays the days, hours, minutes and seconds since the earlier event. The macro is intended to "run" the clocks on the worksheet so they tick along continuously. Some of the timers subtract a date/time from NOW(), but the only computer involved is the one the macro's running on. Anyway, when I manually click Excel's "calculate now" button, Excel has no trouble completing all the operations in a second or less. So the problem must have something to do with how the macro executes. Thanks for taking time to reply.