Need help with double countdown timer

As for as displaying integer seconds as time, try something like this...

Please Login or Register  to view this content.

Divide the Integer that represents seconds by 86400 (number of seconds in a day).


Or this...

Please Login or Register  to view this content.

Read this to understand how time is represented in Excel

How Excel Stores Dates And Times

Hi AlphaFrog - thanks for your reply. Good news, both methods for displaying integer as time work .
I am making good progress on this project and I now know how time is stored in Excel.
I still don't how to implement the procedure to pause time and make the other clock start and vice versa.
Also, I've had a go an implementing an increment (if an increment exists) to both clocks - the increment only kicks in after the initial time is started and is added when the clock is restarted for each player.

Would it be possible for you to take a look at the updated file?

Originally Posted by reddwarf

I would like the clock to pause when 'stop' is clicked. Also, when paused, the countdown should forced the other timer to start from its last position, and vice versa until the time reaches zero.


I still don't how to implement the procedure to pause time and make the other clock start and vice versa.
Also, I've had a go an implementing an increment (if an increment exists) to both clocks - the increment only kicks in after the initial time is started and is added when the clock is restarted for each player.

I don't fully understand the interaction you want. You refer to the clock and the other clock; That doesn't mean much to me. Can you better describe exactly what you to do from start to finish?