Thread: How to set the time in millisecond
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith Fred Smith is offline
external usenet poster
  
Posts: 623
Default How to set the time in millisecond
You're close. The format you want is hh:mm:ss.000

--
Regards,
Fred


"jaizovic" wrote in
message ...

I have a problem to calculate the difference between two time in
millisecond
current setting only works for hh:mm:ss setting. e.g. 12:59:59 AM

I want to set a time something like hh:mm:ss:SSS e.g 13:59:59:123 PM
this setting will help to measure the differences between two time in
millisecond.

Can anybody help me...

If macros is the only solution, how to use the macro.



regards


--
jaizovic
------------------------------------------------------------------------
jaizovic's Profile:
http://www.excelforum.com/member.php...o&userid=37057
View this thread: http://www.excelforum.com/showthread...hreadid=568181



Reply With QuoteReply With Quote