performancegoogle-sheetstimetimercountdown

How to show "game over" when the Countdown is over in google sheets

I have added the COUNTDOWN timer to my google sheet by the code that comes below, when the time is over the value gets negative and it shows "#NUM!". I want it to show "GAME OVER!" when the time is up.

=int(B6-now())&" "&if(days(B6,now())>1,"Days","Day")&" : "&hour(B6-now())&" "&if(hour(B6-now())>1,"Hours","Hour")&" : "&MINUTE(B6-now())&" "&if(MINUTE(B6-now())>1,"Minutes","Minute",if(($B6-now())<0,"COMPLETE"))
Solution

  • use:

    =IFERROR(int(B6-now())&" "&if(days(B6,now())>1,"Days","Day")&" : "&hour(B6-now())&" "&if(hour(B6-now())>1,"Hours","Hour")&" : "&MINUTE(B6-now())&" "&if(MINUTE(B6-now())>1,"Minutes","Minute",if(($B6-now())<0,"COMPLETE")), "Game Over")