I have attached a spreadsheet that I would like to use to help me time/manage events. I've seen various iterations of timers, etc.. but I can't seem to figure out how to fit things all together to accomplish what I need.
In a nutshell I want to be able to press a button and have the countdowns in the next unpopulated column start. (each column represents a date and these events run each day but may have different times each day)
The countdowns to the Pre-Events occur at specific times and I want to figure out how long it is from the set time until the current time. These times countdown for each pre-event in their appropriate cells.
When I am within the "popup reminder" timeframe specified at the top of the worksheet I want a POPUP to display in very large letters and numbers displaying the amount of time UNTIL the Event and the Text from Column B indicating the Event Name - "Pre-Event1 Name", etc.
The popup would also be counting down and when it got to zero it would then go negative indicating it was past the time. There would be a button on the popup that when pressed would record the Actual time it was pressed into the appropriate field and close the popup window. The idea for the popup is that you can see it on the screen from a distance...and it has the ability for you to respond to it to end it. (Perhaps when it went negative the color of the text or background could change to red?)
Once it processed all of the PRE-Events (6 maximum but there could be fewer) it would just be sitting there with the clock at the top running.
When I was ready for the acutal events I would click the CountUP button and it would figure the correct column and populate the Event Start time on Row 31. This time will be used to calculate the PopUP notification events for the 3 Event times... using the same logic as above.
Is this doable?
Bookmarks