![]() |
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 |
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