Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Timer in Excel
I need to set a timer at 1 minute interval for various time ranges. Start
time is in cell C2, end time is in cell D2. This time frame is mostly less than 2 hours, but on rare occassions can be upto 4 hours. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Timer in Excel
Hi I am little confused...when you say set a timer at a1 minute
interval ..do you mean display the time elaspsed every minute...for the period between C2 and D2??if so where do you want to see the elapsed time? FloMM2 wrote: I need to set a timer at 1 minute interval for various time ranges. Start time is in cell C2, end time is in cell D2. This time frame is mostly less than 2 hours, but on rare occassions can be upto 4 hours. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Timer in Excel
Try something like
Sub CallTimer() If nTime = 0 Then nTime = Range("B2").Value Else Range("A1").Value = Format(Now(), "hh:mm") End If If nTime < Range("D2").Value Then nTime = nTime + TimeSerial(0, 1, 0) Application.OnTime Date + nTime, "CallTimer" End If End Sub -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "FloMM2" wrote in message ... I need to set a timer at 1 minute interval for various time ranges. Start time is in cell C2, end time is in cell D2. This time frame is mostly less than 2 hours, but on rare occassions can be upto 4 hours. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Timer in Excel
Steve,
Sorry: Starting in column B, at cell B4 thru B?? at 1 minute interval until time is equal to cell D2. Thanx :-) FloMM2 "stevebriz" wrote: Hi I am little confused...when you say set a timer at a1 minute interval ..do you mean display the time elaspsed every minute...for the period between C2 and D2??if so where do you want to see the elapsed time? FloMM2 wrote: I need to set a timer at 1 minute interval for various time ranges. Start time is in cell C2, end time is in cell D2. This time frame is mostly less than 2 hours, but on rare occassions can be upto 4 hours. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Timer in Excel
Bob,
I ran your sample, after adding a DIM nTime. It runs, but the data (time) is not added to the spreadsheet. Thanx:-) FloMM2 "Bob Phillips" wrote: Try something like Sub CallTimer() If nTime = 0 Then nTime = Range("B2").Value Else Range("A1").Value = Format(Now(), "hh:mm") End If If nTime < Range("D2").Value Then nTime = nTime + TimeSerial(0, 1, 0) Application.OnTime Date + nTime, "CallTimer" End If End Sub -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "FloMM2" wrote in message ... I need to set a timer at 1 minute interval for various time ranges. Start time is in cell C2, end time is in cell D2. This time frame is mostly less than 2 hours, but on rare occassions can be upto 4 hours. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Timer in Excel
Sub CallTimer()
If nTime = 0 Then nTime = Range("B2").Value Else Range("A1").End(xlup)(2).Value = Format(Now(), "hh:mm") End If If nTime < Range("D2").Value Then nTime = now() + TimeSerial(0, 1, 0) Application.OnTime ntime, "CallTimer" End If End Sub If you are actively using the computer while this is running, it could cause variations in the times posted. -- Regards, Tom Ogilvy loMM2" wrote in message ... Bob, I ran your sample, after adding a DIM nTime. It runs, but the data (time) is not added to the spreadsheet. Thanx:-) FloMM2 "Bob Phillips" wrote: Try something like Sub CallTimer() If nTime = 0 Then nTime = Range("B2").Value Else Range("A1").Value = Format(Now(), "hh:mm") End If If nTime < Range("D2").Value Then nTime = nTime + TimeSerial(0, 1, 0) Application.OnTime Date + nTime, "CallTimer" End If End Sub -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "FloMM2" wrote in message ... I need to set a timer at 1 minute interval for various time ranges. Start time is in cell C2, end time is in cell D2. This time frame is mostly less than 2 hours, but on rare occassions can be upto 4 hours. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Timer in Excel | Excel Discussion (Misc queries) | |||
Stopping a Timer / Running a timer simultaneously on Excel | Excel Discussion (Misc queries) | |||
timer in Excel VBA | Excel Programming | |||
Excel VBA - Timer | Excel Programming | |||
Excel VBA - Timer | Excel Programming |