Countdown Timer in Excel

[msiyab]

Hi Guys,

I need a simple formula or a macro, which simply counts down to zero once I enter the Days:Hours or Hours:Minutes (if less than 1 day).

For example, I enter 4 days and the cell has a countdown timer going as 3 days 23 Hours (no need for minutes its above one day). So if below 1 day, then the countdown should appear as 23 Hours 59 Minutes and so on. Once the timer runs to zero, "Done" message should appear on that cell.

The thing is I need multiple timers to run under Column I, so the formula/macro should not be limited to one timer.

Please help!

[msiyab]

Ok let me try to explain it in aonther way.
I have a list of tasks with deadlines associated with it. Follwoing is the details of the columns in the worksheet.

Coulmn A - Task
Column B - Days
Column C - Hours
Column D - Minutes

Now, based on the numbers I enter in Column B, C & D, the timer should run in column E.
For example, Col B - 6, Col C - 11, Then in Col E - 6 Days 10 Hours 59 Minutes should appear (counting down until zero)
If only, Col C & D are mentioned, then Col E should show X Hours Y Minutes and so on.

Once the countdown reaches zero, Col E should show "Done"


P.S.: Tried on ozgrid.com too, but no help so far.

[aju.thomas]

Hi,

Hope this will help you.

Attachment 1500[/SIZE]

[msiyab]

Thanks for the help!! This is useful!!

But can you make a formula without the "date" (column B) criteria?

And also, could you please explain how to add the "Refresh" button in my worksheet?

[aju.thomas]

without a start date formula cannot identify how many days are left. so column B (Date) cannot be avoided.
You can move the column or hide the column.

for refresh button
Insert ActiveX Command button, Right click and select View Code
inside the code, just type "calculate"

Eg:-

 Private Sub CommandButton1_Click()
Calculate
End Sub