Adding and Subtracting a Time with MilliSeconds
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.
|