View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default Adding and Subtracting a Time with MilliSeconds

Doh! Forget it, I thought you had 3 colons there


--
Regards,

Peo Sjoblom



"Peo Sjoblom" wrote in message
...
That would be text for Excel, the custom format that would include
milliseconds in Excel is

hh:mm:ss.000

it's a period not a colon so you would need to convert them

=--SUBSTITUTE(A1,":",".0",3)


formatted as above would work for you examples but if you would have

10:39:55:211

then this might work

=IF(LEN(MID(A1,FIND(".",SUBSTITUTE(A1,":",".",3))+ 1,255))=3,--SUBSTITUTE(A1,":",".",3),--SUBSTITUTE(A1,":",".0",3))


remember to format as

hh:mm:ss.000


--
Regards,

Peo Sjoblom



"carl" wrote in message
...
My time comes in like this:

10:39:41:91
10:39:54.01

hours:minutes:seconds.milliseconds.

Is there a way to add and subtract times in this format ?

Thank you in advance.