Running multiple timers

I made timer program that has 3 timers, one that runs from start to stop and two other that can be stopped and continued. Now my problem is how I get all three timers running at same time.
Here's excel file so its easier to explore it: Combat%20laskuri.xls

Please Login or Register  to view this content.

This might help:
http://www.xl-logic.com/xl_files/vba/active_clock.zip

Col

What's the error?

Hmm. It works fine for me opened from the zip file. Unless you're doing something else (?) I have no idea what's causing that. Sorry!

Anyway, the idea is that you have one cell, call it "time_now", whose value is the current time. You then schedule a macro to update this cell every second, like this:

Please Login or Register  to view this content.

"SetTime" starts the timer, "Disable" stops it. "Recalc" will be run every second by the "Application.ontime" command and will update "time_now".

Your macros to start and stop your 3 timers will now use formulae linked to "time_now", e.g.

=time_now-38977.6132315972

where 38977.6132315972 is the value of Now as I write this. Each time time_now is updated, all these formulae will also change.



C