Spreadsheet: 220403d1363145503-div-0-error-with-averageifs-datasheet
Sheet: 3-4-2013

# | Service | Time Arrived | Time Taken | Time Finished | Wait Time | Appt Length | Appt. Type | Sched. Type (1,2,3) |  | Avg. Wait Time by Sched. Type | Appt. Type | Avg. Wait Time (Min) | Appt. Type | Avg. Length (Minutes)
1 | C | 08:21:00 | 08:37:00 | 09:03:00 |  |  | C | 2 | C-1 |  | C |  | C
2 | C | 08:23:00 | 08:46:00 | 09:27:00 |  |  | C | 1 | C-2 |  | H |  | H
3 | C | 08:29:00 | 08:51:00 | 09:11:00 |  |  | C | 2 | C-3 |  | E |  | E
4 | C | 08:35:00 | 08:56:00 | 09:32:00 |  |  | C | 3 | H-1 |  | S |  | S
5 | C | 08:43:00 | 08:57:00 | 09:26:00 |  |  | C | 2 | H-2
6 | C | 08:46:00 | 09:05:00 | 09:39:00 |  |  | C | 1 | H-3 |  | C
7 | H | 08:48:00 | 08:51:00 | 09:48:00 |  |  | H | 2 | E-1
8 | C | 08:49:00 | 09:33:00 | 10:29:00 |  |  | C | 1 | E-2
9 | E | 08:52:00 | 08:53:00 | 11:16:00 |  |  | E | 2 | E-3
10 | C | 08:54:00 | 09:08:00 | 09:42:00 |  |  | C | 1 | S-1
11 | C | 08:55:00 | 09:35:00 | 10:24:00 |  |  | C | 1 | S-2
12 | C | 09:00:00 | 09:02:00 | 09:17:00 |  |  | C | 2 | S-3
13 | C | 09:02:00 | 09:47:00 | 10:20:00 |  |  | C | 2
14 | S | 09:06:00 | 09:50:00 | 10:33:00 |  |  | S | 2
15 | C | 09:06:00 | 09:09:00 | 09:41:00 |  |  | C | 1
16 | H | 09:10:00 | 09:20:00 | 10:29:00 |  |  | H | 3
17 | S | 09:11:00 | 09:16:00 | 09:59:00 |  |  | S | 3
18 | C | 09:11:00 | 09:32:00 | 09:47:00 |  |  | C | 2
19 | C | 09:14:00 | 09:30:00 | 10:00:00 |  |  | C | 2
20 | C | 09:17:00 | 09:22:00 | 10:25:00 |  |  | C | 3
21 | S | 09:22:00 | 09:49:00 | 09:50:00 |  |  | S | 3
22 | H | 09:24:00 | 09:27:00 | 11:11:00 |  |  | H | 3
23 | C | 09:24:00 | 09:33:00 | 10:06:00 |  |  | C | 2
24 | C | 09:25:00 | 09:57:00 | 10:09:00 |  |  | C | 1
25 | S | 09:42:00 | 10:28:00 | 11:12:00 |  |  | S | 3
26 | C | 09:42:00 | 10:02:00 | 10:26:00 |  |  | C | 2
27 | C | 09:44:00 | 10:02:00 | 10:33:00 |  |  | C | 2
28 | S | 09:45:00 | 10:12:00 | 10:44:00 |  |  | S | 1
29 | C | 09:50:00 | 10:34:00 | 11:09:00 |  |  | C | 2
30 | C | 09:55:00 | 10:30:00 | 11:15:00 |  |  | C | 2
31 | C | 09:59:00 | 10:05:00 | 10:20:00 |  |  | C | 2
32 | C | 10:06:00 | 10:22:00 | 10:40:00 |  |  | C | 2
33 | C | 10:08:00 | 10:28:00 | 11:05:00 |  |  | C | 2
34 | S | 10:11:00 | 10:36:00 | 10:55:00 |  |  | S | 2
35 | S | 10:13:00 | 10:13:00 | 10:24:00 | 0 |  | S | 3
36 | C | 10:14:00 | 10:37:00 | 11:12:00 |  |  | C | 2
37 | H | 10:16:00 | 10:50:00 | 13:29:00 |  |  | H | 2
38 | S | 10:27:00 | 10:32:00 | 10:45:00 |  |  | S | 1
39 | S | 10:35:00 | 10:35:00 | 11:01:00 | 0 |  | S | 1
40 | C | 10:38:00 | 10:39:00 | 11:28:00 |  |  | C | 1
41 | S | 10:42:00 | 11:24:00 | 12:11:00 |  |  | S | 1
42 | C | 10:43:00 | 10:58:00 | 11:30:00 |  |  | C | 2
43 | C | 10:52:00 | 11:09:00 | 11:20:00 |  |  | C | 2
44 | C | 10:53:00 | 11:34:00 | 12:06:00 |  |  | C | 1
45 | H | 10:56:00 | 11:12:00 | 13:56:00 |  |  | H | 3
46 | C | 11:00:00 | 11:11:00 | 11:31:00 |  |  | C | 2
47 | C | 11:01:00 | 11:39:00 | 12:14:00 |  |  | C | 1
48 | C | 11:04:00 | 11:14:00 | 11:41:00 |  |  | C | 2
49 | C | 11:06:00 | 11:46:00 | 12:17:00 |  |  | C | 1
50 | S | 11:06:00 | 11:22:00 | 12:18:00 |  |  | S | 2
51 | C | 11:07:00 | 11:17:00 | 12:01:00 |  |  | C | 2
52 | H | 11:08:00 | 11:15:00 | 13:26:00 |  |  | H | 3
53 | C | 11:15:00 | 11:21:00 | 11:50:00 |  |  | C | 2
54 | S | 11:16:00 | 12:11:00 | 12:59:00 |  |  | S | 1
55 | C | 11:17:00 | 11:38:00 | 12:25:00 |  |  | C | 2
56 | S | 11:19:00 | 12:25:00 | 12:51:00 |  |  | S | 2
57 | C | 11:22:00 | 12:15:00 | 12:36:00 |  |  | C | 2
58 | C | 11:26:00 | 12:40:00 | 13:31:00 |  |  | C | 2
59 | E | 11:36:00 | 11:39:00 | 14:54:00 |  |  | E | 2
60 | C | 11:37:00 | 12:54:00 | 13:15:00 |  |  | C | 2
61 | C | 11:38:00 | 12:08:00 | 12:36:00 |  |  | C | 2
62 | C | 11:42:00 | 13:05:00 | 13:51:00 |  |  | C | 1
63 | C | 11:44:00 | 12:53:00 | 13:16:00 |  |  | C | 2
64 | C | 11:44:00 | 12:10:00 | 12:27:00 |  |  | C | 2
65 | C | 11:45:00 | 12:38:00 | 13:01:00 |  |  | C | 2
66 | C | 11:55:00 | 12:29:00 | 13:47:00 |  |  | C | 2
67 | C | 12:00:00 | 13:00:00 | 13:23:00 |  |  | C | 1
68 | H | 12:03:00 | 12:58:00 | 14:29:00 |  |  | H | 2
69 | C | 12:11:00 | 12:20:00 | 12:51:00 |  |  | C | 1
70 | H | 12:11:00 | 13:57:00 | 16:19:00 |  |  | H | 2
71 | C | 12:16:00 | 13:19:00 | 13:55:00 |  |  | C | 1
72 | H | 12:24:00 | 13:13:00 | 14:09:00 |  |  | H | 2
73 | C | 12:24:00 | 13:47:00 | 15:44:00 |  |  | C | 3
74 | C | 12:26:00 | 13:36:00 | 13:57:00 |  |  | C | 1
75 | E | 12:30:00 | 15:02:00 | 15:10:00 |  |  | E | 2
76 | C | 12:42:00 | 14:09:00 | 14:45:00 |  |  | C | 1
77 | C | 12:45:00 | 14:37:00 | 14:49:00 |  |  | C | 1
78 | S | 12:50:00 | 12:54:00 | 14:36:00 |  |  | S | 3
79 | E | 12:55:00 | 14:10:00 | 15:05:00 |  |  | E | 1
80 | C | 12:58:00 | 14:31:00 | 16:03:00 |  |  | C | 2
81 | C | 13:04:00 | 14:41:00 | 15:18:00 |  |  | C | 1
82 | H | 13:08:00 | 13:09:00 | 13:51:00 |  |  | H | 3
83 | C | 13:10:00 | 14:11:00 | 14:29:00 |  |  | C | 2
84 | C | 13:12:00 | 14:19:00 | 14:57:00 |  |  | C | 2
85 | C | 13:13:00 | 14:32:00 | 15:00:00 |  |  | C | 2
86 | C | 13:15:00 | 15:25:00 | 16:00:00 |  |  | C | 2
87 | E | 13:16:00 | 13:59:00 | 14:58:00 |  |  | E | 1
88 | C | 13:19:00 | 15:00:00 | 15:20:00 |  |  | C | 2
89 | H | 13:26:00 | 13:57:00 | 17:00:00 |  |  | H | 3
90 | H | 13:36:00 | 14:05:00 | 15:37:00 |  |  | H | 3
91 | H | 13:48:00 | 15:07:00 | 17:14:00 |  |  | H | 2
92 | C | 13:57:00 | 15:37:00 | 16:04:00 |  |  | C | 2
93 | C | 14:07:00 | 15:12:00 | 15:56:00 |  |  | C | 2
94 | S | 14:14:00 | 15:46:00 | 16:09:00 |  |  | S | 1
95 | E | 14:36:00 | 15:09:00 | 16:03:00 |  |  | E | 1
96 | C | 14:36:00 | 15:33:00 | 16:17:00 |  |  | C | 2
97 | C | 14:43:00 | 15:39:00 | 16:04:00 |  |  | C | 2
98 | C | 14:45:00 | 14:59:00 | 15:24:00 |  |  | C | 1
99 | E | 14:53:00 | 14:55:00 | 15:23:00 |  |  | E | 2
100 | C | 14:54:00 | 15:57:00 | 16:58:00 |  |  | C | 1
101 | C | 14:57:00 | 16:08:00 | 16:28:00 |  |  | C | 1
102 | C | 15:11:00 | 15:59:00 | 16:17:00 |  |  | C | 2
103 | S | 16:10:00 | 16:17:00 | 16:28:00 |  |  | S | 1
104 | S | 16:22:00 | 16:31:00 | 16:51:00 |  |  | S | 2
Patients with a scheduled appointment with a provider waited half as long as those who didn’t
Overall patients arrived 8 minutes before their scheduled appointment