Multiple countdown timers - error when a number reaches zero

[gsbkv10]

I'm trying to make multiple countdown timers in one sheet.
Column A: On/Off switch
Column B: is where countdown shows
Column C: the length of the time that I want to countdown from
Since it's MULTIPLE countdown timer, the Rows would look like, countdown timer 1, countdown timer 2, countdown timer 3....

The problem is that the error occurs when a countdown reaches zero. How do I fix this?
How do I make a switch change back to "OFF" when a countdown is done?

Please Login or Register  to view this content.

[Winon]

Hello gsbkv10,

The attached sample Workbook is not in the correct "Saved" format, and errors out on downloading it. Please remove the Workbook, save it with a xlsm or xlsb Extension format and upload it again.

Regards.

[gsbkv10]

Oh Sorry
I have uploaded it again

[Winon]

Hi gsbkv10,

Sorry for the long delay.

Your request is quite tricky, and the best I could come up with so far is shown in the attached sample Workbook.

Please do try it in the meantime, while I shall have a peek at it again at a later stage, it is already 1:29 am here by us and way past my nap!LOL

Regards.