Working With Times / Milliseconds
My times come in like this:
TimeA TimeB
120509324389.00 120509324395.00
120510001924.00 120510001927.00
The first 4 characters are month and day (which I do not need). The last 2
characters are milliseconds. I am trying to convert these times into the
table below and I also need a formula to subtract the 2 times.
TimeA TimeB Difference
9:32:43.89 9:32:43.95
10:00:19.24 10:00:19.27
Thank you in advance.
|