View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carl Carl is offline
external usenet poster
 
Posts: 361
Default 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.