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