Hi,

I want to put a stopwatch in a label. What is Format to
display minutes, seconds, and milliseconds?

Thanks in advance,

Herman

hh:mm:ss.000

But I think you only get 100ths of seconds.

If you want a something for timing the speed of a macro
you might want to take a look at
http://www.mvps.org/dmcritchie/excel/slowresp.htm#timer

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Herman" wrote in message ...
Hi,

I want to put a stopwatch in a label. What is Format to
display minutes, seconds, and milliseconds?

Thanks in advance,

Herman

David,

100ths seem to work for me (Excel 2000, XP) in a worksheet cell.

However, when trying to apply it to a label

Label1.Caption = Format(Range("A1"), "hh:mm:ss.000")

shows simply as .000

but

Label1.Caption = Range("A1").Text

shows okay.


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"David McRitchie" wrote in message
...
hh:mm:ss.000

But I think you only get 100ths of seconds.

If you want a something for timing the speed of a macro
you might want to take a look at
http://www.mvps.org/dmcritchie/excel/slowresp.htm#timer

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Herman" wrote in message
...
Hi,

I want to put a stopwatch in a label. What is Format to
display minutes, seconds, and milliseconds?

Thanks in advance,

Herman