Excel function to find difference of timestamps in milliseconds?

S

Srikanth

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
Excel - Wich Function should I use? 1
Every New Tasks Wants to Start in the Future 1
how to find time difference between timestamps to a millisecond? 2
How to getting text labels to show up in scatter chart. 0
Word macro that can call cells out of Excel for a find and replace 0
Insert Index into a Table 1

Top