Hello, I require help be able to filter the following date and time information on a 5 min interval.
Timestamp Value
04-Jan-11 11:05:31 AM EST On
06-Jan-11 10:12:27 AM EST On
23-Jan-11 11:55:06 AM EST Off
23-Jan-11 11:58:05 AM EST On
23-Jan-11 3:37:31 PM EST Off
23-Jan-11 3:42:28 PM EST On
23-Jan-11 6:25:03 PM EST Off
23-Jan-11 6:28:47 PM EST On
23-Jan-11 9:32:14 PM EST Off
23-Jan-11 9:36:27 PM EST On
24-Jan-11 12:19:22 AM EST Off
24-Jan-11 12:21:58 AM EST On
24-Jan-11 3:05:50 AM EST Off
24-Jan-11 3:08:15 AM EST On
24-Jan-11 5:55:55 AM EST Off
24-Jan-11 5:58:50 AM EST On
24-Jan-11 8:39:30 AM EST Off
24-Jan-11 8:45:54 AM EST On
24-Jan-11 11:18:27 AM EST Off
24-Jan-11 11:20:50 AM EST On
24-Jan-11 7:35:07 PM EST On
24-Jan-11 7:35:19 PM EST On
25-Jan-11 1:16:56 AM EST On
26-Jan-11 4:28:27 PM EST On
26-Jan-11 4:28:37 PM EST On
15-Mar-11 1:35:53 PM EDT On
18-Mar-11 9:48:48 AM EDT On
18-Mar-11 9:49:00 AM EDT On
23-Mar-11 2:34:26 PM EDT On
23-Mar-11 7:50:27 PM EDT On
23-Mar-11 7:50:38 PM EDT On
23-Mar-11 8:34:38 PM EDT On
Any help on this would be great. I am not sure if I can use and advanced filter or if I have to use a marco or something like that. I am in Excel but nothing to special so a step by step procedure would be great.
Thanks
Timestamp Value
04-Jan-11 11:05:31 AM EST On
06-Jan-11 10:12:27 AM EST On
23-Jan-11 11:55:06 AM EST Off
23-Jan-11 11:58:05 AM EST On
23-Jan-11 3:37:31 PM EST Off
23-Jan-11 3:42:28 PM EST On
23-Jan-11 6:25:03 PM EST Off
23-Jan-11 6:28:47 PM EST On
23-Jan-11 9:32:14 PM EST Off
23-Jan-11 9:36:27 PM EST On
24-Jan-11 12:19:22 AM EST Off
24-Jan-11 12:21:58 AM EST On
24-Jan-11 3:05:50 AM EST Off
24-Jan-11 3:08:15 AM EST On
24-Jan-11 5:55:55 AM EST Off
24-Jan-11 5:58:50 AM EST On
24-Jan-11 8:39:30 AM EST Off
24-Jan-11 8:45:54 AM EST On
24-Jan-11 11:18:27 AM EST Off
24-Jan-11 11:20:50 AM EST On
24-Jan-11 7:35:07 PM EST On
24-Jan-11 7:35:19 PM EST On
25-Jan-11 1:16:56 AM EST On
26-Jan-11 4:28:27 PM EST On
26-Jan-11 4:28:37 PM EST On
15-Mar-11 1:35:53 PM EDT On
18-Mar-11 9:48:48 AM EDT On
18-Mar-11 9:49:00 AM EDT On
23-Mar-11 2:34:26 PM EDT On
23-Mar-11 7:50:27 PM EDT On
23-Mar-11 7:50:38 PM EDT On
23-Mar-11 8:34:38 PM EDT On
Any help on this would be great. I am not sure if I can use and advanced filter or if I have to use a marco or something like that. I am in Excel but nothing to special so a step by step procedure would be great.
Thanks
Last edited: