Spreadsheet: 186039d1349902396-how-to-round-up-down-time-formats-hh-mm-ss-incoming_31secs_10-9-12
Sheet: TAPIT_10-9-12

Date | Time | Duration | Rounded Up/Down | Extension | Incoming | Cost
2012-10-09 00:00:00 | 07:13:00 | 00:01:37 |  | 10 | I | 0
2012-10-09 00:00:00 | 07:51:00 | 00:02:54 |  | 11 | I | 0
2012-10-09 00:00:00 | 08:01:00 | 00:04:17 |  | 10 | I | 0
2012-10-09 00:00:00 | 07:59:00 | 00:06:19 |  | 11 | I | 0
2012-10-09 00:00:00 | 08:07:00 | 00:00:42 |  | 10 | I | 0
2012-10-09 00:00:00 | 08:07:00 | 00:02:23 |  | 11 | I | 0
2012-10-09 00:00:00 | 08:05:00 | 00:05:51 |  | 12 | I | 0
2012-10-09 00:00:00 | 08:08:00 | 00:04:35 |  | 11 | I | 0
2012-10-09 00:00:00 | 08:07:00 | 00:05:55 |  | 10 | I | 0
2012-10-09 00:00:00 | 08:13:00 | 00:00:50 |  | 12 | I | 0
2012-10-09 00:00:00 | 08:13:00 | 00:06:47 |  | 11 | I | 0
2012-10-09 00:00:00 | 08:19:00 | 00:01:15 |  | 12 | I | 0
2012-10-09 00:00:00 | 08:23:00 | 00:02:09 |  | 11 | I | 0
2012-10-09 00:00:00 | 08:23:00 | 00:03:04 |  | 12 | I | 0
2012-10-09 00:00:00 | 08:27:00 | 00:02:51 |  | 11 | I | 0
2012-10-09 00:00:00 | 08:28:00 | 00:02:47 |  | 12 | I | 0
2012-10-09 00:00:00 | 08:30:00 | 00:02:17 |  | 10 | I | 0
2012-10-09 00:00:00 | 08:32:00 | 00:03:27 |  | 11 | I | 0
2012-10-09 00:00:00 | 08:33:00 | 00:02:43 |  | 10 | I | 0
2012-10-09 00:00:00 | 08:31:00 | 00:05:09 |  | 12 | I | 0
2012-10-09 00:00:00 | 08:35:00 | 00:03:02 |  | 11 | I | 0
2012-10-09 00:00:00 | 08:39:00 | 00:06:25 |  | 11 | I | 0
2012-10-09 00:00:00 | 08:40:00 | 00:06:46 |  | 12 | I | 0
2012-10-09 00:00:00 | 08:47:00 | 00:06:51 |  | 11 | I | 0
2012-10-09 00:00:00 | 08:53:00 | 00:02:44 |  | 10 | I | 0
2012-10-09 00:00:00 | 09:31:00 | 00:07:56 |  | 12 | I | 0
2012-10-09 00:00:00 | 09:38:00 | 00:02:41 |  | 11 | I | 0
2012-10-09 00:00:00 | 09:38:00 | 00:06:59 |  | 10 | I | 0
2012-10-09 00:00:00 | 09:43:00 | 00:01:50 |  | 11 | I | 0
2012-10-09 00:00:00 | 09:45:00 | 00:03:08 |  | 12 | I | 0
2012-10-09 00:00:00 | 09:50:00 | 00:00:45 |  | 10 | I | 0
2012-10-09 00:00:00 | 08:57:00 | 00:01:28 |  | 12 | I | 0
2012-10-09 00:00:00 | 08:59:00 | 00:02:02 |  | 10 | I | 0
Date | Time | Duration | Rounded Up/Down | Extension | Incoming | Cost
2012-10-09 00:00:00 | 09:00:00 | 00:01:51 |  | 12 | I | 0
2012-10-09 00:00:00 | 09:02:00 | 00:03:23 |  | 12 | I | 0
2012-10-09 00:00:00 | 09:03:00 | 00:03:05 |  | 10 | I | 0
2012-10-09 00:00:00 | 09:06:00 | 00:00:43 |  | 12 | I | 0
2012-10-09 00:00:00 | 09:07:00 | 00:00:41 |  | 12 | I | 0
2012-10-09 00:00:00 | 09:08:00 | 00:01:12 |  | 12 | I | 0
2012-10-09 00:00:00 | 09:02:00 | 00:07:19 |  | 10 | I | 0
2012-10-09 00:00:00 | 09:02:00 | 00:09:24 |  | 11 | I | 0
2012-10-09 00:00:00 | 09:09:00 | 00:02:53 |  | 10 | I | 0
2012-10-09 00:00:00 | 09:10:00 | 00:03:03 |  | 10 | I | 0
2012-10-09 00:00:00 | 09:10:00 | 00:03:18 |  | 10 | I | 0
2012-10-09 00:00:00 | 09:12:00 | 00:02:07 |  | 11 | I | 0
2012-10-09 00:00:00 | 09:13:00 | 00:01:21 |  | 10 | I | 0
2012-10-09 00:00:00 | 09:17:00 | 00:01:04 |  | 12 | I | 0
2012-10-09 00:00:00 | 09:20:00 | 00:00:51 |  | 11 | I | 0
2012-10-09 00:00:00 | 09:32:00 | 00:02:21 |  | 10 | I | 0
2012-10-09 00:00:00 | 09:33:00 | 00:04:25 |  | 11 | I | 0
2012-10-09 00:00:00 | 09:37:00 | 00:02:21 |  | 11 | I | 0
2012-10-09 00:00:00 | 09:48:00 | 00:03:15 |  | 12 | I | 0
2012-10-09 00:00:00 | 09:51:00 | 00:03:33 |  | 11 | I | 0
2012-10-09 00:00:00 | 09:55:00 | 00:01:01 |  | 10 | I | 0
2012-10-09 00:00:00 | 09:56:00 | 00:02:06 |  | 12 | I | 0
2012-10-09 00:00:00 | 09:57:00 | 00:03:51 |  | 11 | I | 0
2012-10-09 00:00:00 | 10:03:00 | 00:01:54 |  | 11 | I | 0
2012-10-09 00:00:00 | 10:28:00 | 00:03:50 |  | 11 | I | 0
2012-10-09 00:00:00 | 10:31:00 | 00:05:26 |  | 10 | I | 0
2012-10-09 00:00:00 | 10:38:00 | 00:03:16 |  | 10 | I | 0
2012-10-09 00:00:00 | 10:33:00 | 00:08:31 |  | 11 | I | 0
2012-10-09 00:00:00 | 10:45:00 | 00:00:38 |  | 12 | I | 0
2012-10-09 00:00:00 | 10:49:00 | 00:02:40 |  | 11 | I | 0
2012-10-09 00:00:00 | 11:22:00 | 00:12:23 |  | 10 | I | 0
2012-10-09 00:00:00 | 11:39:00 | 00:01:04 |  | 12 | I | 0
2012-10-09 00:00:00 | 11:41:00 | 00:02:48 |  | 11 | I | 0
Date | Time | Duration | Rounded Up/Down | Extension | Incoming | Cost
2012-10-09 00:00:00 | 11:53:00 | 00:09:10 |  | 13 | I | 0
2012-10-09 00:00:00 | 11:57:00 | 00:06:08 |  | 11 | I | 0
2012-10-09 00:00:00 | 11:51:00 | 00:23:40 |  | 12 | I | 0
2012-10-09 00:00:00 | 13:00:00 | 00:02:53 |  | 13 | I | 0
2012-10-09 00:00:00 | 13:04:00 | 00:01:47 |  | 10 | I | 0
2012-10-09 00:00:00 | 13:01:00 | 00:09:28 |  | 11 | I | 0
2012-10-09 00:00:00 | 13:12:00 | 00:12:34 |  | 11 | I | 0
2012-10-09 00:00:00 | 13:26:00 | 00:01:17 |  | 13 | I | 0
2012-10-09 00:00:00 | 13:28:00 | 00:03:47 |  | 11 | I | 0
2012-10-09 00:00:00 | 13:32:00 | 00:00:35 |  | 11 | I | 0
2012-10-09 00:00:00 | 13:23:00 | 00:09:41 |  | 10 | I | 0
2012-10-09 00:00:00 | 13:26:00 | 00:07:54 |  | 13 | I | 0
2012-10-09 00:00:00 | 13:34:00 | 00:00:59 |  | 13 | I | 0
2012-10-09 00:00:00 | 13:35:00 | 00:01:04 |  | 10 | I | 0
2012-10-09 00:00:00 | 13:34:00 | 00:03:31 |  | 13 | I | 0
2012-10-09 00:00:00 | 13:22:00 | 00:16:30 |  | 12 | I | 0
2012-10-09 00:00:00 | 13:34:00 | 00:07:30 |  | 11 | I | 0
2012-10-09 00:00:00 | 13:46:00 | 00:00:52 |  | 10 | I | 0
2012-10-09 00:00:00 | 10:04:00 | 00:01:15 |  | 10 | I | 0
2012-10-09 00:00:00 | 10:00:00 | 00:05:58 |  | 12 | I | 0
2012-10-09 00:00:00 | 10:07:00 | 00:00:50 |  | 12 | I | 0
2012-10-09 00:00:00 | 10:11:00 | 00:02:26 |  | 11 | I | 0
2012-10-09 00:00:00 | 10:16:00 | 00:02:27 |  | 10 | I | 0
2012-10-09 00:00:00 | 10:15:00 | 00:04:27 |  | 11 | I | 0
2012-10-09 00:00:00 | 10:20:00 | 00:04:29 |  | 12 | I | 0
2012-10-09 00:00:00 | 10:23:00 | 00:03:10 |  | 11 | I | 0
2012-10-09 00:00:00 | 10:26:00 | 00:01:07 |  | 12 | I | 0
2012-10-09 00:00:00 | 10:25:00 | 00:01:59 |  | 10 | I | 0
2012-10-09 00:00:00 | 10:54:00 | 00:01:42 |  | 10 | I | 0
2012-10-09 00:00:00 | 11:00:00 | 00:02:11 |  | 11 | I | 0
2012-10-09 00:00:00 | 11:02:00 | 00:04:01 |  | 10 | I | 0
2012-10-09 00:00:00 | 11:02:00 | 00:11:19 |  | 12 | I | 0
2012-10-09 00:00:00 | 11:13:00 | 00:03:47 |  | 11 | I | 0
Date | Time | Duration | Rounded Up/Down | Extension | Incoming | Cost
2012-10-09 00:00:00 | 11:20:00 | 00:01:07 |  | 11 | I | 0
2012-10-09 00:00:00 | 11:16:00 | 00:05:58 |  | 10 | I | 0
2012-10-09 00:00:00 | 11:16:00 | 00:09:54 |  | 12 | I | 0
2012-10-09 00:00:00 | 11:21:00 | 00:06:44 |  | 11 | I | 0
2012-10-09 00:00:00 | 13:01:00 | 00:11:18 |  | 12 | I | 0
2012-10-09 00:00:00 | 13:11:00 | 00:03:17 |  | 13 | I | 0
2012-10-09 00:00:00 | 13:12:00 | 00:02:47 |  | 12 | I | 0
2012-10-09 00:00:00 | 13:13:00 | 00:01:57 |  | 10 | I | 0
2012-10-09 00:00:00 | 13:15:00 | 00:02:21 |  | 13 | I | 0
2012-10-09 00:00:00 | 13:19:00 | 00:05:04 |  | 13 | I | 0
2012-10-09 00:00:00 | 13:46:00 | 00:01:09 |  | 13 | I | 0
2012-10-09 00:00:00 | 13:47:00 | 00:05:54 |  | 15 | I | 0
2012-10-09 00:00:00 | 13:48:00 | 00:05:51 |  | 10 | I | 0
2012-10-09 00:00:00 | 13:48:00 | 00:05:58 |  | 13 | I | 0
2012-10-09 00:00:00 | 13:46:00 | 00:08:47 |  | 11 | I | 0
2012-10-09 00:00:00 | 13:44:00 | 00:11:28 |  | 12 | I | 0
2012-10-09 00:00:00 | 13:56:00 | 00:00:56 |  | 12 | I | 0
2012-10-09 00:00:00 | 13:55:00 | 00:01:31 |  | 13 | I | 0
2012-10-09 00:00:00 | 13:54:00 | 00:05:01 |  | 10 | I | 0
2012-10-09 00:00:00 | 14:00:00 | 00:00:59 |  | 11 | I | 0
2012-10-09 00:00:00 | 13:57:00 | 00:07:13 |  | 12 | I | 0
2012-10-09 00:00:00 | 14:04:00 | 00:01:18 |  | 11 | I | 0
2012-10-09 00:00:00 | 13:53:00 | 00:17:40 |  | 13 | I | 0
2012-10-09 00:00:00 | 14:06:00 | 00:06:34 |  | 12 | I | 0
2012-10-09 00:00:00 | 14:10:00 | 00:07:59 |  | 11 | I | 0
2012-10-09 00:00:00 | 14:19:00 | 00:01:29 |  | 13 | I | 0
2012-10-09 00:00:00 | 14:26:00 | 00:04:29 |  | 11 | I | 0
2012-10-09 00:00:00 | 14:34:00 | 00:00:48 |  | 11 | I | 0
2012-10-09 00:00:00 | 14:26:00 | 00:09:00 |  | 13 | I | 0
2012-10-09 00:00:00 | 14:37:00 | 00:00:38 |  | 11 | I | 0
2012-10-09 00:00:00 | 14:41:00 | 00:01:05 |  | 11 | I | 0
2012-10-09 00:00:00 | 14:41:00 | 00:02:41 |  | 13 | I | 0
2012-10-09 00:00:00 | 14:43:00 | 00:01:14 |  | 11 | I | 0
Date | Time | Duration | Rounded Up/Down | Extension | Incoming | Cost
2012-10-09 00:00:00 | 14:42:00 | 00:03:23 |  | 12 | I | 0
2012-10-09 00:00:00 | 14:43:00 | 00:02:27 |  | 15 | I | 0
2012-10-09 00:00:00 | 14:43:00 | 00:04:13 |  | 10 | I | 0
2012-10-09 00:00:00 | 14:45:00 | 00:07:26 |  | 13 | I | 0
2012-10-09 00:00:00 | 14:51:00 | 00:02:01 |  | 11 | I | 0
2012-10-09 00:00:00 | 15:03:00 | 00:03:44 |  | 11 | I | 0
2012-10-09 00:00:00 | 15:08:00 | 00:01:14 |  | 12 | I | 0
2012-10-09 00:00:00 | 15:29:00 | 00:04:51 |  | 11 | I | 0
2012-10-09 00:00:00 | 15:34:00 | 00:01:02 |  | 13 | I | 0
2012-10-09 00:00:00 | 15:36:00 | 00:01:56 |  | 11 | I | 0
2012-10-09 00:00:00 | 15:42:00 | 00:01:32 |  | 11 | I | 0
2012-10-09 00:00:00 | 15:47:00 | 00:02:59 |  | 11 | I | 0
2012-10-09 00:00:00 | 15:52:00 | 00:02:29 |  | 11 | I | 0
2012-10-09 00:00:00 | 15:37:00 | 00:19:50 |  | 13 | I | 0
2012-10-09 00:00:00 | 15:44:00 | 00:14:34 |  | 12 | I | 0
2012-10-09 00:00:00 | 15:53:00 | 00:08:08 |  | 10 | I | 0
2012-10-09 00:00:00 | 16:02:00 | 00:03:31 |  | 12 | I | 0
2012-10-09 00:00:00 | 15:56:00 | 00:10:02 |  | 13 | I | 0
2012-10-09 00:00:00 | 16:07:00 | 00:01:49 |  | 12 | I | 0
2012-10-09 00:00:00 | 16:09:00 | 00:00:45 |  | 13 | I | 0
2012-10-09 00:00:00 | 16:10:00 | 00:01:00 |  | 12 | I | 0
2012-10-09 00:00:00 | 16:10:00 | 00:02:12 |  | 13 | I | 0
2012-10-09 00:00:00 | 16:15:00 | 00:01:16 |  | 13 | I | 0
2012-10-09 00:00:00 | 16:15:00 | 00:03:31 |  | 12 | I | 0
2012-10-09 00:00:00 | 16:18:00 | 00:02:55 |  | 13 | I | 0
2012-10-09 00:00:00 | 16:19:00 | 00:01:49 |  | 12 | I | 0
2012-10-09 00:00:00 | 16:18:00 | 00:04:47 |  | 13 | I | 0
2012-10-09 00:00:00 | 16:23:00 | 00:01:37 |  | 13 | I | 0
2012-10-09 00:00:00 | 16:26:00 | 00:01:11 |  | 13 | I | 0
2012-10-09 00:00:00 | 16:41:00 | 00:03:50 |  | 13 | I | 0
2012-10-09 00:00:00 | 16:46:00 | 00:00:56 |  | 13 | I | 0
2012-10-09 00:00:00 | 16:46:00 | 00:00:44 |  | 13 | I | 0
2012-10-09 00:00:00 | 16:41:00 | 00:06:56 |  | 12 | I | 0
Date | Time | Duration | Rounded Up/Down | Extension | Incoming | Cost
2012-10-09 00:00:00 | 16:48:00 | 00:01:06 |  | 13 | I | 0
2012-10-09 00:00:00 | 16:49:00 | 00:01:34 |  | 12 | I | 0
2012-10-09 00:00:00 | 16:50:00 | 00:01:29 |  | 10 | I | 0
2012-10-09 00:00:00 | 15:04:00 | 00:07:23 |  | 13 | I | 0
2012-10-09 00:00:00 | 15:18:00 | 00:03:04 |  | 13 | I | 0
2012-10-09 00:00:00 | 15:21:00 | 00:02:16 |  | 11 | I | 0
2012-10-09 00:00:00 | 15:22:00 | 00:00:43 |  | 13 | I | 0
2012-10-09 00:00:00 | 15:21:00 | 00:03:10 |  | 12 | I | 0
2012-10-09 00:00:00 | 16:27:00 | 00:01:49 |  | 13 | I | 0
2012-10-09 00:00:00 | 16:26:00 | 00:02:38 |  | 15 | I | 0
2012-10-09 00:00:00 | 16:25:00 | 00:04:31 |  | 12 | I | 0
2012-10-09 00:00:00 | 16:32:00 | 00:02:56 |  | 13 | I | 0
2012-10-09 00:00:00 | 16:37:00 | 00:02:48 |  | 13 | I | 0