0

After much research and finding and utilizing solutions I've found for creating a long term "stopwatch timer" in Google Sheets, I've done it. It works the way I want it to and it displays the information the way I want it to. However, I can't seem to be able to create an effective way to stop or pause the timer without it disappearing. If someone could help me devise a solution for capturing stop time on the following timer It would be greatly appreciated. Please keep in mind that I'm trying to stay way from writing functions in code in the scripts section.

Here is what I'm using on the page concurrent with a couple dropdowns as triggers. FYI, I did have to limit iterations in the options menu for this to work.

=IF(C2= "1-Up", IF(D2="1-Yes", (int(now()-E2)&" "&if(days(now(),E2)>1,"Days","Day")&" : "&hour(now()-E2)&" "&if(hour(now()-E2)>1,"Hours","Hour")&" : "&MINUTE(now()-E2)&" "&if(MINUTE(now()-E2)>1,"Minutes","Minute")), ""),"")

This long winded function allows for the timer, as well as displays the information the way I wanted. Now I just need to be able to "freeze" it.

1
  • Hi, welcome to WebApps. I'm trying to stay way from writing functions in code in the scripts section. A formula is dynamic-it is ALWAYS running. So to expect that one can "freeze" a formula is, I suggest, unrealistic. There is also the issue of NOW(); if you pause the formula what are the implications for NOW() - would you pause NOW() too? In any event, I (and I could be wrong) can't imagine a way to "pause/freeze" the formula without using a script.
    – Tedinoz
    May 4 at 1:55

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.