| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel function to find difference of timestamps in milliseconds?
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find does not work in Excel 2003 | Excel Discussion (Misc queries) | |||
| Creating a Custom Excel Function to Calculate Gini Coefficients | Excel Worksheet Functions | |||
| IS THERE AN INTERPOLATION FUNCTION IN EXCEL 2003 | Excel Worksheet Functions | |||
| "Group" function very slow with Excel 2003 :( ... While very quick with Excel2000 :O) | Excel Discussion (Misc queries) | |||
| Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
Linear Mode
