Countdown Timer

[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

 

[Paul]

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

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.