countdown timer

[okjectivity]

Hi everyone,

Thanks for the incredible community you built here. This is my first post ever

I'm trying to make a countdown timer (in minutes and seconds, mm:ss) that can show tenths of seconds in the last minute (ss.0). I thought it could be possible since excel seems to have milliseconds, but I don't succeed. Does anybody know if it's possible? If so, any clue as to how to do it?

Thanks so much, everyone
All the best
Mik

 

[igold]

Welcome to the MrExcel Forum. I don't know how much this will help you, but when I want to time how long it takes for a code to run, I use this. The number of decimal places of the Seconds in determined by the Round Function.

Sub Codetimer()

    Dim StartTime As Double
    Dim SecondsElapsed As Double

   'Remember time when macro starts
    StartTime = Timer

    'YOUR CODE HERE

    'Determine how many seconds code took to run
    SecondsElapsed = Round(Timer - StartTime, 2)

    'Notify user in seconds
    MsgBox "This code ran successfully in " & SecondsElapsed & " seconds", vbInformation
    
End Sub

I hope this helps.

 

[okjectivity]

thanks a lot! will give this approach a try and will keep you posted. Thanks so much for the feedback, igold!

 

[igold]

You're welcome, I was happy to help. I was hoping that this would give you a jump start to what you are tying to accomplish. Thanks for the feedback.