Wintimer time format

[Jaye7]

I have the following script as part of a wintimer which lists the full time, can someone please help with a script that lists only minutes and seconds.

Removing the hh does not work as then the minutes always display as 06 for some reason.

Dim strTime As String
    strTime = Format$(Now(), "hh:mm:ss")
    'strTime = Format$(Now(), "h:mm:ss am/pm")

 

[Scott Huish]

Duplicate post.

See http://www.mrexcel.com/forum/showthread.php?t=560996

Please do not post duplicate questions. Please add any clarifications to the original thread.

From the FAQ:

Rule #9:
Do not post duplicate questions. Posts of a duplicate nature will be deleted or locked. All related follow-ups, be they further related questions, clarifications or bumps, should be posted back to the original thread.