Countdown timer/stopwatch

[jhakans]

Hi!

Im looking to make a countdown timer where I can put in a value and it starts to count down and that's no problem, managed to do this but now to the problem. When the counter reach 00:00 I want another one or the same counter to start counting negative -00:01 -00:02 -00:03 and so on. And when I stop the timer I want the excel to collect and save the negative time in a sheet.

Is this possible? and if so can some one help me to figure this out?

Best regards

[vba_php]

there is no such thing as negative time. however, you could probably use a custom number format (time format), or possibly even use the time TIME(), DATE() or FORMAT() functions to get it to look like what you want when you capture it. for instance (and I did not test this):

="-" & format("10:00", "short time")

if you've already figure out how to set the timer, more than likely, in order to reverse it ad start counting negatively, you will simply have to let the timer run on the positive side and concat a negative sign when you want to stop it. like:

string variable = "-" & timer_value

[jhakans]

It dosent neessary need to be negative I can visualize this in another way. Something like this I'm thinking. The hard part for me is to start the other timer automatically when the first one has stopped. and also automatically collects the data when I manually press on the stop button.


Attachment 696703

[vba_php]

i'm not sure I understand what you're asking. also, I don't know how you uploaded the file, but some folks here cannot see those when they are uploaded that way. can you do it another way?

[jhakans]

Oh, something like this I mean

[jhakans]

Lets say the green timer is set to 02:00 and when I hit "start" it starts to count down. When the green timer has reach 00:00 I want the red timer to start count upwards from 00:00 till I hit the stop button. and lets say I stop the red timer at 01:15 then I want excel to store that data in another sheet.

And now I can only get the green timer to work. I cant figure out the logic between the two timers and how to store the data when hitting the stop button.

I will give you some context.

The green timer will show how much time you have to do a task if you've not managed to complete the task in time I want the red timer to count how much time you have gone over. And then store this in a sheet so I can follow up the total "overtime" when all tasks are completed.

BR

[vba_php]

what is that image supposed to show? do you want a negative value to appear when the time is stopped at 4:50?

vad visar den bilden? vill du att ett negativt värde ska visas när tiden stoppas klockan 4:50?

[torachan]

One of mine from yesteryear.
Set countdown to time allowed > tick set timer > start
the time recorded at Stop is total including overrun.
torachan.

[jhakans]

One of mine from yesteryear.
Set countdown to time allowed > tick set timer > start
the time recorded at Stop is total including overrun.
torachan.

Thank you! this is exactly what I'm looking for!!

[vba_php]

and...some other relevant things I found years ago....