Spreadsheet: 48802d1248109333-dcount-times-adding-up-dcount-help
Sheet: Sheet1

Store | blank | blank | item | sale_time | Sale Hour
1 |  |  | cookies | 11:45:45 | 12:00:00
2 |  |  | cookies | 06:23:25 | 06:00:00
3 |  |  | cookies | 10:46:36 | 11:00:00
4 |  |  | cookies | 11:19:13 | 11:00:00
5 |  |  | cookies | 16:15:48 | 16:00:00
6 |  |  | cookies | 18:16:37 | 18:00:00
7 |  |  | cookies | 18:40:26 | 19:00:00
8 |  |  | cookies | 20:42:47 | 21:00:00
9 |  |  | cookies | 09:25:01 | 09:00:00
10 |  |  | cookies | 13:57:12 | 14:00:00
1 |  |  | cookies | 17:50:53 | 18:00:00
2 |  |  | cookies | 09:51:17 | 10:00:00
3 |  |  | cookies | 10:18:07 | 10:00:00
4 |  |  | cookies | 06:52:32 | 07:00:00
6 |  |  | cookies | 17:29:41 | 17:00:00
5 |  |  | cookies | 12:13:36 | 12:00:00
4 |  |  | cookies | 08:51:38 | 09:00:00
8 |  |  | cookies | 11:19:21 | 11:00:00
9 |  |  | cookies | 13:09:44 | 13:00:00
1 |  |  | cookies | 17:57:48 | 18:00:00
2 |  |  | cookies | 16:11:23 | 16:00:00
5 |  |  | cookies | 15:30:46 | 16:00:00
6 |  |  | cookies | 11:23:59 | 11:00:00
8 |  |  | cookies | 12:56:13 | 13:00:00
9 |  |  | cookies | 05:16:56 | 05:00:00
4 |  |  | cookies | 14:53:38 | 15:00:00
7 |  |  | cookies | 17:17:29 | 17:00:00
6 |  |  | cookies | 05:05:27 | 05:00:00
3 |  |  | cookies | 02:54:08 | 03:00:00
1 |  |  | cookies | 22:04:33 | 22:00:00
2 |  |  | cookies | 17:34:33 | 18:00:00
5 |  |  | cookies | 19:07:30 | 19:00:00
4 |  |  | cookies | 08:01:17 | 08:00:00
6 |  |  | cookies | 04:57:41 | 05:00:00
8 |  |  | cookies | 12:43:46 | 13:00:00
4 |  |  | cookies | 12:13:59 | 12:00:00
4 |  |  | cookies | 16:34:22 | 17:00:00
3 |  |  | cookies | 23:25:29 | 23:00:00
10 |  |  | cookies | 08:23:54 | 08:00:00
2 |  |  | cookies | 19:49:48 | 20:00:00
10 |  |  | cookies | 21:58:42 | 22:00:00
10 |  |  | cookies | 13:40:44 | 14:00:00
10 |  |  | cookies | 03:41:33 | 04:00:00
10 |  |  | cookies | 15:59:52 | 16:00:00
9 |  |  | cookies | 20:12:13 | 20:00:00
9 |  |  | cookies | 22:15:47 | 22:00:00
9 |  |  | cookies | 21:40:20 | 22:00:00
9 |  |  | cookies | 18:29:00 | 18:00:00
8 |  |  | cookies | 20:24:58 | 20:00:00
8 |  |  | cookies | 12:33:53 | 13:00:00
8 |  |  | cookies | 08:55:36 | 09:00:00
5 |  |  | cookies | 16:37:02 | 17:00:00
5 |  |  | cookies | 11:02:41 | 11:00:00
5 |  |  | cookies | 20:08:11 | 20:00:00
4 |  |  | cookies | 19:09:55 | 19:00:00
6 |  |  | cookies | 21:48:13 | 22:00:00
6 |  |  | cookies | 15:19:59 | 15:00:00
4 |  |  | cookies | 11:20:46 | 11:00:00
4 |  |  | cookies | 11:31:22 | 12:00:00
4 |  |  | cookies | 01:28:10 | 01:00:00
4 |  |  | cookies | 19:10:54 | 19:00:00
7 |  |  | cookies | 20:12:58 | 20:00:00
6 |  |  | cookies | 08:18:55 | 08:00:00
7 |  |  | cookies | 12:52:37 | 13:00:00
7 |  |  | cookies | 14:58:02 | 15:00:00
7 |  |  | cookies | 08:33:34 | 09:00:00
7 |  |  | cookies | 14:04:24 | 14:00:00
8 |  |  | cookies | 08:48:12 | 09:00:00
8 |  |  | cookies | 14:56:31 | 15:00:00
8 |  |  | cookies | 12:50:17 | 13:00:00
8 |  |  | cookies | 03:25:42 | 03:00:00
9 |  |  | cookies | 23:04:00 | 23:00:00
9 |  |  | cookies | 11:07:11 | 11:00:00
9 |  |  | cookies | 12:46:40 | 13:00:00
3 |  |  | cookies | 16:06:14 | 16:00:00
3 |  |  | cookies | 20:57:09 | 21:00:00
3 |  |  | cookies | 18:23:34 | 18:00:00
3 |  |  | cookies | 20:01:30 | 20:00:00
10 |  |  | cookies | 05:50:10 | 06:00:00
10 |  |  | cookies | 14:56:49 | 15:00:00
10 |  |  | cookies | 22:48:00 | 23:00:00
2 |  |  | cookies | 16:57:16 | 17:00:00
2 |  |  | cookies | 19:14:54 | 19:00:00
2 |  |  | cookies | 09:24:12 | 09:00:00
2 |  |  | cookies | 00:03:00 | 1900-01-01 00:00:00
1 |  |  | cookies | 10:56:39 | 11:00:00
1 |  |  | cookies | 17:26:59 | 17:00:00
1 |  |  | cookies | 14:32:45 | 15:00:00
1 |  |  | cookies | 16:53:47 | 17:00:00