Excel function to find difference of timestamps in milliseconds?

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
 
A

Ardus Petus

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
Calculating time difference 14
Comparing time values which have milliseconds in them e.g 10:20:30 5
Average the difference between 2 times 4
calculate difference of time 2
Difference between two times in seconds 1

Top