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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel calcutions using date/timestamps 1
Extracting milliseconds from a time field 9
how to find time difference between timestamps to a millisecond? 2
Timestamp for changes in any row of cells? 2
How to set the time in millisecond 1
timestamps in excel 4
Formatting datetime problems importing data from mysql db 2
Excel 2007 Crashes when Saving to .xls 2

Back
Top