Spreadsheet: 153196d1335800618-how-to-calculate-the-average-cycle-time-average-cycle-time_jpr73
Sheet: Sheet1

Date | Time | Truck |  |  |  |  |  |  |  |  |  | How to calculate the average cycle time
2012-01-01 00:00:00 | 01:02:56 | Truck 1 |  |  | Average Cycle Time |  |  |  | Moyenne de Time
2012-01-01 00:00:00 | 05:16:43 | Truck 1 |  |  | Truck 1 |  |  |  | Truck | Total
2012-01-01 00:00:00 | 11:46:56 | Truck 1 |  |  | Truck 2 |  |  |  | Truck 1 | 11:55:26.652000
2012-01-01 00:00:00 | 16:13:06 | Truck 1 |  |  | Truck 3 |  |  |  | Truck 2 | 11:55:26.652000
2012-01-01 00:00:00 | 20:43:27 | Truck 1 |  |  |  |  |  |  | Truck 3 | 12:25:06.227000
2012-01-01 00:00:00 | 01:02:56 | Truck 2 |  |  |  |  |  |  | Total général | 12:05:02.397000
2012-01-01 00:00:00 | 05:16:43 | Truck 2
2012-01-01 00:00:00 | 11:46:56 | Truck 2
2012-01-01 00:00:00 | 16:13:06 | Truck 2
2012-01-01 00:00:00 | 20:43:27 | Truck 2
2012-01-01 00:00:00 | 05:16:43 | Truck 3
2012-01-01 00:00:00 | 11:46:56 | Truck 3
2012-01-01 00:00:00 | 16:13:06 | Truck 3
2012-01-01 00:00:00 | 20:43:27 | Truck 3
2012-01-02 00:00:00 | 01:32:41 | Truck 1
2012-01-02 00:00:00 | 07:55:28 | Truck 1
2012-01-02 00:00:00 | 13:40:10 | Truck 1
2012-01-02 00:00:00 | 18:23:30 | Truck 1
2012-01-02 00:00:00 | 23:50:00 | Truck 1
2012-01-02 00:00:00 | 01:32:41 | Truck 2
2012-01-02 00:00:00 | 07:55:28 | Truck 2
2012-01-02 00:00:00 | 13:40:10 | Truck 2
2012-01-02 00:00:00 | 18:23:30 | Truck 2
2012-01-02 00:00:00 | 23:50:00 | Truck 2
2012-01-02 00:00:00 | 01:32:41 | Truck 3
2012-01-02 00:00:00 | 07:55:28 | Truck 3
2012-01-02 00:00:00 | 13:40:10 | Truck 3
2012-01-02 00:00:00 | 18:23:30 | Truck 3
2012-01-02 00:00:00 | 23:50:00 | Truck 3
2012-01-03 00:00:00 | 05:31:51 | Truck 1
2012-01-03 00:00:00 | 09:12:23 | Truck 1
2012-01-03 00:00:00 | 05:31:51 | Truck 2
2012-01-03 00:00:00 | 09:12:23 | Truck 2
2012-01-03 00:00:00 | 05:31:51 | Truck 3
2012-01-03 00:00:00 | 09:12:23 | Truck 3
2012-01-04 00:00:00 | 00:14:55 | Truck 1
2012-01-04 00:00:00 | 04:00:18 | Truck 1
2012-01-04 00:00:00 | 09:41:56 | Truck 1
2012-01-04 00:00:00 | 13:21:40 | Truck 1
2012-01-04 00:00:00 | 18:25:03 | Truck 1
2012-01-04 00:00:00 | 22:16:30 | Truck 1
2012-01-04 00:00:00 | 00:14:55 | Truck 2
2012-01-04 00:00:00 | 04:00:18 | Truck 2
2012-01-04 00:00:00 | 09:41:56 | Truck 2
2012-01-04 00:00:00 | 13:21:40 | Truck 2
2012-01-04 00:00:00 | 18:25:03 | Truck 2
2012-01-04 00:00:00 | 22:16:30 | Truck 2
2012-01-04 00:00:00 | 00:14:55 | Truck 3
2012-01-04 00:00:00 | 04:00:18 | Truck 3
2012-01-04 00:00:00 | 09:41:56 | Truck 3
2012-01-04 00:00:00 | 13:21:40 | Truck 3
2012-01-04 00:00:00 | 18:25:03 | Truck 3
2012-01-04 00:00:00 | 22:16:30 | Truck 3
2012-01-05 00:00:00 | 02:20:37 | Truck 1
2012-01-05 00:00:00 | 02:20:37 | Truck 2
2012-01-05 00:00:00 | 02:20:37 | Truck 3
2012-01-07 00:00:00 | 10:51:59 | Truck 1
2012-01-07 00:00:00 | 14:56:49 | Truck 1
2012-01-07 00:00:00 | 19:34:06 | Truck 1
2012-01-07 00:00:00 | 23:22:09 | Truck 1
2012-01-07 00:00:00 | 10:51:59 | Truck 2
2012-01-07 00:00:00 | 14:56:49 | Truck 2
2012-01-07 00:00:00 | 19:34:06 | Truck 2
2012-01-07 00:00:00 | 23:22:09 | Truck 2
2012-01-07 00:00:00 | 10:51:59 | Truck 3
2012-01-07 00:00:00 | 14:56:49 | Truck 3
2012-01-07 00:00:00 | 19:34:06 | Truck 3
2012-01-07 00:00:00 | 23:22:09 | Truck 3