Excel function to find difference of timestamps in milliseconds?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to know if there is any formula in excel to get the difference of
timestamps in milliseconds.
For Example: I want to find the timestamp difference between the following
times
22:55:12:830 (Say this is in cell A1)
22:55:13:098 (Say this is in cell A2)
How do we get the difference of these two timestamps?
Please post your answers to this query.

Thanks in Advance,
Srikanth
 
Format your cells as custom hh:mm:ss.000
Enter:
=B1-A1
That will show the expected result 00:00:00.268

HTH
 
Back
Top