Countdown

[chris miller]

Hi,

I was wondering if anyone would be able to tell me the formula to countdown
the days, hours, minutes and seconds from the time I open a spreadsheeet
until a given time in the future,

Cheers

 

[Gary''s Student]

Three steps:

First put this little workbook event macro in the workbook code area:

Private Sub Workbook_Open()
Sheets("Sheet1").Range("A1").Value = Now
End Sub

Whenever the workbook is openned, the date/time will be recorded in cell A1
of Sheet1 (adjust to suit).

Next format B1 as Custom > mm/dd/yyyy hh:mm:ss
and put the future date/time in B1:

12/25/2008 8:00:00 PM

Finally put the following formula in C1:

=INT(B1-A1) & " days " & TEXT(MOD(B1-A1,1),"hh:mm:ss")