title: calculate time difference in milliseconds excel
body: <p>How do i calculate time difference <strong>in milliseconds</strong> between two columns where value of time has milliseconds component ... i.e. 16:33:44:056. Please refer to column E and J in pic .. i want to calculate <strong>difference in milli seconds between J and E</strong> ... <a href="https://i.stack.imgur.com/35kEg.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/35kEg.png" alt="enter image description here"></a></p>
  
  <p>I have tried using the following formula to alculate difference in milli seconds but its giving incorrect results. =((RIGHT(J1,3))-(RIGHT(E1,3)))</p>