Dear Experts,
I would like to calculate numbers of jobs running at a given launchtime,we have start and end time in data as below:
Product | Header1 | LaunchTime | Start | End |
Macnozyfec Eenub 13 CJA-ZPU | Published Application | 4/24/2014 11:40:52 PM | 4/24/2014 11:40:50 PM | 4/24/2014 11:53:42 PM |
Macnozyfec Eenub 13 CJA-ZPU | Published Application | 4/24/2014 11:54:59 PM | 4/24/2014 11:54:56 PM | 4/25/2014 5:06:54 AM |
Macnozyfec Eenub 13 CJA-ZPU | Published Application | 4/25/2014 3:18:51 PM | 4/25/2014 3:18:48 PM | 4/25/2014 8:19:38 PM |
Macnozyfec Eenub 13 CJA-ZPU | Published Application | 4/25/2014 3:19:14 PM | 4/25/2014 3:19:12 PM | 4/25/2014 6:48:56 PM |
Macnozyfec Eenub 13 CJA-ZPU | Published Application | 4/25/2014 6:49:30 PM | 4/25/2014 6:49:26 PM | 4/25/2014 7:25:21 PM |
Macnozyfec Eenub 13 CJA-ZPU | Published Application | 4/25/2014 8:10:02 PM | 4/25/2014 8:10:00 PM | 4/26/2014 1:37:53 AM |
Macnozyfec Eenub 13 CJA-ZPU | Published Application | 4/25/2014 8:10:30 PM | 4/25/2014 8:10:27 PM | 4/26/2014 1:37:52 AM |
Macnozyfec Eenub 13 CJA-ZPU | Published Application | 4/25/2014 9:06:30 AM | 4/25/2014 9:06:28 AM | 4/25/2014 10:58:19 AM |
Macnozyfec Eenub 13 CJA-ZPU | Published Application | 4/25/2014 9:42:29 PM | 4/25/2014 9:42:26 PM | 4/26/2014 1:37:46 AM |
Macnozyfec Eenub 13 CJA-ZPU | Published Application | 4/25/2014 11:01:13 AM | 4/25/2014 11:01:10 AM | 4/25/2014 3:18:06 PM |
for e.g
if user select '4/25/2014 3:19:14 PM' in 4th row then he should get two rows only i.e 3rd and 4th row.
Thanks
AJ