Tuesday, August 14, 2012

yogi_Set Up A CountDown Counter To Count Down By The Minute

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #697   Aug 14, 2012     www.energyefficientbuild.com.

user ethertonm said: (http://productforums.google.com/forum/?zx=knoiadu3x64v#!category-topic/docs/spreadsheets/410MXSxG36w%5B1-25%5D)
Is it possible to creat an automatic countdown in spreadsheet, or alternatively is there a function similar to NOW() which won't refresh?
Okay, I have a timer that will go off in 3 hours, 40 minutes. I want to create a cell that will show that time from now, so my thoughts were =NOW()+03:40:00 . This gives me the time from now. The problem is, NOW() is a changing variable, so instead of giving me that time from when I first called the function, it simply always gives me 3 hours and 40 minutes in the future from the actual current time. I need something similar to NOW() that doesn't actually refresh, EVER.
following is a solution to the problem