View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tim H[_2_] Tim H[_2_] is offline
external usenet poster
 
Posts: 20
Default Countdown Timer - not stopwatch

How do I write a countdown timer macro in excel if I have an end date / time
that i want to countdown till? For example, I have in cell A1 - "12/31/2007
11:59:59 PM" and I want to display a countdown timer starting in A2 showing
"X months Y days Z hours AA Minutes BB seconds until New Year's Day"


Thanks.