Using Mac Office 2011 to write this, will execute the spreadsheet on a system with Windows Office 2007.
I'm attempting to do a countdown timer where it calculates how much time is left until either 30 minutes past the hour, or to the top of the hour.
My next step is to figure out how to calculate when I have 1 minute remaining, 30 seconds, 10 seconds, 9, 8, 7, 6, etc.
Most of the timer routines I can find here, have the value of 86400. In fact, the script that VoG wrote for me in another post, uses:
I'm assuming that since it's when the timer hits Zero, that it translate the time of 00:00 to less than or equal to 86400.
What I'm looking for is a formula to figure out what values I would need to equate to 30, 10, etc to set up if statements where I can change the color of the clock or cell where the clock is displayed at 30, 10, and every second before it hit's zero.
Hope that makes some sense.
Thanks again,
Ralph
I'm attempting to do a countdown timer where it calculates how much time is left until either 30 minutes past the hour, or to the top of the hour.
My next step is to figure out how to calculate when I have 1 minute remaining, 30 seconds, 10 seconds, 9, 8, 7, 6, etc.
Most of the timer routines I can find here, have the value of 86400. In fact, the script that VoG wrote for me in another post, uses:
Code:
If .Value <= (1 / 86400) Then
What I'm looking for is a formula to figure out what values I would need to equate to 30, 10, etc to set up if statements where I can change the color of the clock or cell where the clock is displayed at 30, 10, and every second before it hit's zero.
Hope that makes some sense.
Thanks again,
Ralph