Countdown time for Excel

[GMDorsey]

I am trying to place a countdown timer on multiple cells so we can track ETA times for jobs we do that we track on a spread sheet each day. Is this possible and if so how do I go about doing it.

 

[SkipVought]

Hi,

Please explain how you intend to use a countdown timer. (BTW, if you do not understand basic EXCEL, you'll have a difficult time implementing something this complex)

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[Bong]

Countdown timer" usually implies some real time function, at least it does to me. From your(OP) spare description, I think you want to have cells that display the remaining time from now to a value in another cell. If that is the case you don't need any VBA and this should probably be in the MSOffice forum. That said, look at the today() function.

_________________
Bob Rashkin

 

[SkipVought]

Bob, That is where he originally posted.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[Bong]

Skip, I guess I don't get what he's after.

_________________
Bob Rashkin

 

[GMDorsey]

Bob,

You are correct.

We use this spread sheet to track the time that we tell customers when we will arrive to the job. When we take the call, we log that we will be on site with in an hour of when the call was recieved. I would need the cell to tell me that the time had expired and for us to follow up with the tech to find out the status of the job he is on.

 

[Bong]

Again, this should be in a different forum.
Let's say you have a date in cell A1: 1/21/2009 4:00:00 PM
In a different cell, where you want your "timer", you have the following formula: =A1-TODAY(), formatted as "number".
The result (49.67) is the decimal number of days remaining.


_________________
Bob Rashkin

 

[GMDorsey]

Great!

Two things!
1st-How do I do this in terms of Time
eg. We normally go no further than an 1 to 1.5 out.
2nd-How do I get the worksheet to recalculate.

Thank you so much for your help. This is great!

 

[SkipVought]

"1st-How do I do this in terms of Time"

The difference is in time. Did you read the FAQ I posted in the other forum?

"2nd-How do I get the worksheet to recalculate."

You probably will not like the results...

sub RunTimer
  dim t, d
  t = timer
  d = 60  'calculate every 60 seconds
  do
    if timer > t + d then Activesheet.calculate
    doevents
  loop
end sub

Then, I'd use Conditional Formatting to CHANGE the cell interior of the DIFFERENCE calculation to YELLOW if within some boundary and RED if it exceeds the alloted time.



Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[GMDorsey]

Skip,

I assume I will have to do this for each individial cell that I want to do this for?

 

[SkipVought]

each individial cell"

ONE formula, copy , select ALL the cells to contain the formula and PASTE.

Of course, each NEW call that comes in, must have it's own START date/time. The corresponding formula COULD be automated using the worksheet_change event, to copy the previous row's formula, for instance.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]