Thread
:
Excel function to find difference of timestamps in milliseconds?
View Single Post
#
2
Posted to microsoft.public.excel.misc
Ardus Petus
external usenet poster
Posts: 718
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
Reply With Quote
Ardus Petus
View Public Profile
Find all posts by Ardus Petus