Countdown Timer

  • Thread starter Thread starter Dirk Diggler
  • Start date Start date
D

Dirk Diggler

I am trying to create a countdown timer which basically allows me t
have a date & time in one cell and another displaying how long there i
left to go. Any ideas? TI
 
Dirk Diggler > said:
I am trying to create a countdown timer which basically allows me to
have a date & time in one cell and another displaying how long there is
left to go. Any ideas? TIA
Click to expand...

For a date and time in A1
=A1-NOW()
will give how long is left. It will recalculate whenever the worksheet
recalculates (i.e. for any edit), or when F9 is pressed. However, to get
this to calculate automatically at fixed time intervals would require a
macro.
 
Back
Top