Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi - I need a little help devising something that will
basically do the following: I have a set of dates of transmissions and I want to find the time between successful transmits. See below: 11/11/04 6:01 DIAL 1-800-827-1159 11/11/04 6:02 Nothing was received. 11/11/04 6:04 DIAL 1-800-827-1159 11/11/04 6:07 DIAL 1-800-827-1159 11/11/04 6:10 DIAL 1-800-827-1159 11/11/04 6:14 DIAL 1-800-827-1159 11/11/04 6:17 DIAL 1-800-827-1159 11/11/04 6:18 Nothing was received. 11/11/04 6:20 DIAL 1-800-827-1159 11/11/04 6:24 DIAL 1-800-827-1159 11/11/04 6:25 Nothing was received. 11/11/04 6:27 DIAL 1-800-827-1159 11/11/04 6:29 2 file(s) received. 11/11/04 6:29 Transmitted Records Deleted from Output Queues 11/11/04 6:31 DIAL 1-800-827-1159 11/11/04 6:35 DIAL 1-800-827-1159 11/11/04 6:38 DIAL 1-800-827-1159 You can see that if a transmission is considered successful, there is some text between the Dialings (nothing was recieved, 2 files recieved, transmitted records deleted..., etc). Only when there is nothing between Dialings was it unsuccesful. How could I go about creating something that would find the time between successful sendings? Any help is greatly appreciated. Donnie. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
Charting data ranges that change | Charts and Charting in Excel | |||
Split combined date time data | Excel Discussion (Misc queries) | |||
Split combined date time data | Excel Discussion (Misc queries) | |||
Split combined date time data | Excel Discussion (Misc queries) |