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!