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.
- here's a link to a copy of the sheet. https://docs.google.com/spreadsheets/d/1_3T3hZj26NSMxnVxXyTtfr-BTWyqAym-mJUPfrjbu8U/edit?usp=sharing