MrExcel Publishing
Your One Stop for Excel Tips & Solutions

milliseconds


Posted by sean tobin on August 17, 2001 3:43 PM

Is there a way to track milliseconds ie, hh:mm:ss:(milliseconds)?


Posted by Mark W. on August 19, 2001 5:44 PM

0.0000115740740740741 is Excel's internal representation
of 1 second (0:00:01). One day is 0.0000115740740740741*86400.
If you divide 0.0000115740740740741 by 1000 you get
1.15740740740741E-08 or 1 millisecond which can be
formatted as hh:mm:ss.000 to get 0:00:00.001.