I'm pulling a list of data from a system via web query into a blank worksheet in Excel, and then I want to copy the rows for a particular time to a particular worksheet (e.g., all Monday data from System worksheet to the Delay worksheet, all Tuesday data from Sistem worksheet to Tues worksheet, etc.).
Sample data - System worksheet
CallerId InitTime AnswerTime Delay
4802590853 1:58:56 AM 2:03:59 AM 5.05 Min
Unavailable 5:08:45 AM 5:13:51 AM 5.10 Min
6026280819 6:16:13 AM 6:31:00 AM 14.78 Min
6022790799 6:56:47 AM 7:02:17 AM 5.50 Min
6027188916 6:56:49 AM 7:04:01 AM 7.20 Min
6027188916 7:27:09 AM 7:32:14 AM 5.08 Min
The resut that I need to see is Delay worksheet
Time Caller Id Init Time Answer Time Delay
12:00AM-12:59AM
0 0 0 0
1:00 AM-1:59 AM
0 0 0 0
2:00 AM-2:59 AM
0 0 0 0
.
.
6:00 AM-6:59 AM
6026280819 6:16:13 AM 6:31:00 AM 14.78 Min
6022790799 6:56:47 AM 7:02:17 AM 5.50 Min
6022790799 6:56:49 AM 7:04:01 AM 7.20 Min
etc...... Until
11:00PM-11:59 PM