Countdown Timer in Excel

[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]