| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Working With Times / Milliseconds
My times come in like this:
TimeA TimeB 120509324389.00 120509324395.00 120510001924.00 120510001927.00 The first 4 characters are month and day (which I do not need). The last 2 characters are milliseconds. I am trying to convert these times into the table below and I also need a formula to subtract the 2 times. TimeA TimeB Difference 9:32:43.89 9:32:43.95 10:00:19.24 10:00:19.27 Thank you in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Number of employees working at given time | Excel Discussion (Misc queries) | |||
| sorting multiple minimum times | Excel Discussion (Misc queries) | |||
| Calculation with Working day of the year | Excel Discussion (Misc queries) | |||
| Charting and analyzing Times' times data for trends | Excel Discussion (Misc queries) | |||
| Trace Dependents and Precedents not working | Excel Worksheet Functions | |||
Threaded Mode
