Spreadsheet: 271918d1382108422-counting-time-example
Sheet: Summary

Using Time Column | 07:00 | 08:00 | 09:00 | 10:00 | 11:00 | 12:00 | 13:00 | 14:00 | 15:00 | 16:00 | 17:00 | 18:00 | 19:00 | Total |  | purchdate | salesman | Time | TIMEVALUE
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-07 00:00:00 | [NAME] | 08:31
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-11 00:00:00 | [NAME] | 08:46
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-02 00:00:00 | [NAME] | 09:15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-12 00:00:00 | [NAME] | 09:19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-14 00:00:00 | [NAME] | 09:21
Using TIMEVALUE Column | 07:00 | 08:00 | 09:00 | 10:00 | 11:00 | 12:00 | 13:00 | 14:00 | 15:00 | 16:00 | 17:00 | 18:00 | 19:00 | Total |  | 2013-10-15 00:00:00 | [NAME] | 09:22
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-05 00:00:00 | [NAME] | 09:29
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-17 00:00:00 | [NAME] | 09:36
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-03 00:00:00 | [NAME] | 09:37
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-14 00:00:00 | [NAME] | 09:39
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-11 00:00:00 | [NAME] | 09:41
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-14 00:00:00 | [NAME] | 09:48
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-14 00:00:00 | [NAME] | 09:52
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-05 00:00:00 | [NAME] | 09:59
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-17 00:00:00 | [NAME] | 10:04
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-01 00:00:00 | [NAME] | 10:07
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-10 00:00:00 | [NAME] | 10:09
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-14 00:00:00 | [NAME] | 10:20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-01 00:00:00 | [NAME] | 10:23
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-03 00:00:00 | [NAME] | 10:23
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-07 00:00:00 | [NAME] | 10:26
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-11 00:00:00 | [NAME] | 10:31
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-17 00:00:00 | [NAME] | 10:33
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-07 00:00:00 | [NAME] | 10:34
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-03 00:00:00 | [NAME] | 10:42
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-08 00:00:00 | [NAME] | 10:42
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-10 00:00:00 | [NAME] | 10:50
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-16 00:00:00 | [NAME] | 10:50
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-14 00:00:00 | [NAME] | 10:57
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-14 00:00:00 | [NAME] | 11:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-15 00:00:00 | [NAME] | 11:01
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-17 00:00:00 | [NAME] | 11:03
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-16 00:00:00 | [NAME] | 11:06
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-04 00:00:00 | [NAME] | 11:14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-02 00:00:00 | [NAME] | 11:24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-02 00:00:00 | [NAME] | 11:24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-08 00:00:00 | [NAME] | 11:25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-03 00:00:00 | [NAME] | 11:30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-09 00:00:00 | [NAME] | 11:33
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-10 00:00:00 | [NAME] | 11:41
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-10 00:00:00 | [NAME] | 11:44
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-14 00:00:00 | [NAME] | 11:51
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-04 00:00:00 | [NAME] | 11:51
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-08 00:00:00 | [NAME] | 11:56
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-03 00:00:00 | [NAME] | 12:02
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-11 00:00:00 | [NAME] | 12:04
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-04 00:00:00 | [NAME] | 12:05
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-12 00:00:00 | [NAME] | 12:06
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-09 00:00:00 | [NAME] | 12:07
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-16 00:00:00 | [NAME] | 12:07
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-16 00:00:00 | [NAME] | 12:09
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-17 00:00:00 | [NAME] | 12:10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-10 00:00:00 | [NAME] | 12:13
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-07 00:00:00 | [NAME] | 12:14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-01 00:00:00 | [NAME] | 12:16
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-12 00:00:00 | [NAME] | 12:22
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-04 00:00:00 | [NAME] | 12:23
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-09 00:00:00 | [NAME] | 12:24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-14 00:00:00 | [NAME] | 12:27
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-17 00:00:00 | [NAME] | 12:33
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-09 00:00:00 | [NAME] | 12:34
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-01 00:00:00 | [NAME] | 12:36
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-11 00:00:00 | [NAME] | 12:41
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-02 00:00:00 | [NAME] | 12:42
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-05 00:00:00 | [NAME] | 12:48
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-14 00:00:00 | [NAME] | 12:48
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-14 00:00:00 | [NAME] | 12:51
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-08 00:00:00 | [NAME] | 12:52
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-14 00:00:00 | [NAME] | 12:54
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-10 00:00:00 | [NAME] | 12:57
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-11 00:00:00 | [NAME] | 13:02
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-07 00:00:00 | [NAME] | 13:06
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-01 00:00:00 | [NAME] | 13:07
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-09 00:00:00 | [NAME] | 13:10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-15 00:00:00 | [NAME] | 13:12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-15 00:00:00 | [NAME] | 13:24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-17 00:00:00 | [NAME] | 13:27
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-11 00:00:00 | [NAME] | 13:28
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-07 00:00:00 | [NAME] | 13:35
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-03 00:00:00 | [NAME] | 13:37
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-01 00:00:00 | [NAME] | 13:42
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-17 00:00:00 | [NAME] | 13:43
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-17 00:00:00 | [NAME] | 13:54
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-03 00:00:00 | [NAME] | 13:55
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-02 00:00:00 | [NAME] | 13:56
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-15 00:00:00 | [NAME] | 14:06
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-10 00:00:00 | [NAME] | 14:14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-17 00:00:00 | [NAME] | 14:30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-08 00:00:00 | [NAME] | 14:32
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-01 00:00:00 | [NAME] | 14:39
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-15 00:00:00 | [NAME] | 14:39
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-16 00:00:00 | [NAME] | 14:42
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-15 00:00:00 | [NAME] | 14:44
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-15 00:00:00 | [NAME] | 14:50
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-07 00:00:00 | [NAME] | 14:51
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-04 00:00:00 | [NAME] | 14:57
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-17 00:00:00 | [NAME] | 15:12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-14 00:00:00 | [NAME] | 15:15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-09 00:00:00 | [NAME] | 15:20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-16 00:00:00 | [NAME] | 15:22
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-07 00:00:00 | [NAME] | 15:24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-03 00:00:00 | [NAME] | 15:26
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-10 00:00:00 | [NAME] | 15:28
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-16 00:00:00 | [NAME] | 15:29
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-11 00:00:00 | [NAME] | 15:32
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-14 00:00:00 | [NAME] | 15:42
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-16 00:00:00 | [NAME] | 15:43
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-05 00:00:00 | [NAME] | 15:47
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-01 00:00:00 | [NAME] | 15:49
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-08 00:00:00 | [NAME] | 15:50
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-08 00:00:00 | [NAME] | 15:53
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-17 00:00:00 | [NAME] | 15:54
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-07 00:00:00 | [NAME] | 16:08
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-01 00:00:00 | [NAME] | 16:09
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-10 00:00:00 | [NAME] | 16:10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-09 00:00:00 | [NAME] | 16:16
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-18 00:00:00 | [NAME] | 16:19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-18 00:00:00 | [NAME] | 16:24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-15 00:00:00 | [NAME] | 16:24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-16 00:00:00 | [NAME] | 16:28
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-09 00:00:00 | [NAME] | 16:29
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-16 00:00:00 | [NAME] | 16:29
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-01 00:00:00 | [NAME] | 16:34
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-08 00:00:00 | [NAME] | 16:38
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-11 00:00:00 | [NAME] | 16:38
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-11 00:00:00 | [NAME] | 16:49
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-11 00:00:00 | [NAME] | 16:55
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-02 00:00:00 | [NAME] | 17:01
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-04 00:00:00 | [NAME] | 17:03
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-15 00:00:00 | [NAME] | 17:05
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-11 00:00:00 | [NAME] | 17:11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-02 00:00:00 | [NAME] | 17:27
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-17 00:00:00 | [NAME] | 17:29
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-04 00:00:00 | [NAME] | 17:45
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-08 00:00:00 | [NAME] | 17:53
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-08 00:00:00 | [NAME] | 18:02
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-17 00:00:00 | [NAME] | 18:06
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-04 00:00:00 | [NAME] | 18:16
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-18 00:00:00 | [NAME] | 18:22
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-10 00:00:00 | [NAME] | 18:27
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-08 00:00:00 | [NAME] | 18:52
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-09 00:00:00 | [NAME] | 20:15