| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| synchronizing timestamp feature with time on video software. | Excel Discussion (Misc queries) | |||
| how to find time difference between timestamps to a millisecond? | New Users to Excel | |||
| formula to determine time range overlap? | Excel Discussion (Misc queries) | |||
| Hot key for time? | Excel Worksheet Functions | |||
| time sheet drop down lists | Excel Discussion (Misc queries) | |||
Linear Mode
