Home |
Search |
Today's Posts |
#1
|
|||
|
|||
count down
i wish to set up a countdown timer showing date + hours, minutes and seconds
i have used the formula =now() for todays correct date and time and a fixed date to countdown to but i cannot get a formula to work to count it down.... |
#2
|
|||
|
|||
Jason,
I know what you need to do just not 100% how to do it. Your problem is that the now formula will only calculate when you click into it. Your need a timing rountine with VBA to calc that cell every so many minutes seconds. I'm at a loss of how to do a VBA timing rountine thou. Sure someone else will know. Cheers Tom "jason l" wrote: i wish to set up a countdown timer showing date + hours, minutes and seconds i have used the formula =now() for todays correct date and time and a fixed date to countdown to but i cannot get a formula to work to count it down.... |
#3
|
|||
|
|||
|
#4
|
|||
|
|||
,
Heres what you need to do. 3 Macros As follows 1. Sub Start() ' ' The_Sub Macro ' Macro recorded 06/04/2005 by Tom Hewitt ' ' Calculate ' RepeatTimer End Sub ========== The first Macro starts the calucation process. Macro 2. Sub RepeatTimer() ' ' Starttimer Macro ' Macro recorded 06/04/2005 by Tom Hewitt ' RunWhen = Now + TimeSerial(0, 0, 1) Application.OnTime earliesttime:=RunWhen, procedu="Start", _ schedule:=True End Sub ========= This repeats the process. On the first line alter the number 1 to the number of seconds you require the calculation interval to be. Macro 3. Sub StopTimer() ' ' StopTimer Macro ' Macro recorded 06/04/2005 by Tom Hewitt ' On Error Resume Next Application.OnTime earliesttime:=RunWhen, _ procedu=cRunWhat, schedule:=False End Sub ======== This stops the timer. Enjoy. Adapted from the linked site mentioned in the thread above. Cheers Tom Hewitt "P Sitaram" wrote: See if you can adapt some of this code: http://www.cpearson.com/excel/ontime.htm |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match Last Occurrence of two numbers and Count to Previous Occurence | Excel Worksheet Functions | |||
Filter Count of Records Retrieved. | Excel Discussion (Misc queries) | |||
SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions | |||
Count number to reach a cumulative value | Excel Worksheet Functions | |||
Count If Formula | Excel Worksheet Functions |