ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to set the time in millisecond (https://www.excelbanter.com/excel-discussion-misc-queries/103106-how-set-time-millisecond.html)

jaizovic

How to set the time in millisecond
 

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


Fred Smith

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





All times are GMT +1. The time now is 11:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com