View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ardus Petus Ardus Petus is offline
external usenet poster
 
Posts: 718
Default Excel function to find difference of timestamps in milliseconds?

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

HTH
--
AP

"Srikanth" a écrit dans le message de
news: ...
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