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
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
No comments:
Post a Comment