Spreadsheet: 703456d1605008958-sum-time-spent-exampletimes
Sheet: Data

Time Start | Role | Time In | Time Out
2020-10-01 05:07:45.621000 | Team One | 00:00:21 | 00:00:00
2020-10-01 05:09:23.610000 | Team One | 00:06:16 | 00:00:00
2020-10-01 05:33:20.513000 | Team One | 00:02:07 | 00:00:00
2020-10-01 05:53:55.099000 | Team One | 00:01:17 | 00:00:00
2020-10-01 06:37:36.144000 | Team One | 00:03:21 | 00:00:00
2020-10-01 06:40:26.570000 | Team One | 00:11:31 | 00:00:00
2020-10-01 06:46:35.549000 | Team One | 00:01:08 | 00:00:00
2020-10-01 06:55:24.937000 | Team One | 00:05:32 | 00:00:00
2020-10-01 06:55:37.540000 | Team One | 00:01:24 | 00:00:00
2020-10-01 07:07:34.083000 | Team One | 00:11:02 | 00:00:00
2020-10-01 07:10:53.634000 | Team One | 00:02:01 | 00:00:00
2020-10-01 07:14:19.232000 | Team One | 00:04:46 | 00:00:00
2020-10-01 07:26:13.390000 | Team One | 00:07:46 | 00:00:00
2020-10-01 07:36:49.845000 | Team One | 00:04:28 | 00:00:00
2020-10-01 07:37:35.305000 | Team One | 00:02:34 | 00:00:00
2020-10-01 07:39:08.224000 | Team One | 00:05:11 | 00:00:00
2020-10-01 07:53:05.833000 | Team One | 00:02:23 | 00:00:00
2020-10-01 07:55:21.052000 | Team One | 00:16:53 | 00:00:00
2020-10-01 07:57:04.741000 | Team One | 00:11:51 | 00:00:00
2020-10-01 07:57:45.096000 | Team One | 00:00:28 | 00:00:00
2020-10-01 07:59:28.409000 | Team One | 00:00:00 | 00:00:00
2020-10-01 08:02:13.086000 | Team One | 00:03:36 | 00:00:00
2020-10-01 08:09:56.914000 | Team One | 00:04:01 | 00:00:00
2020-10-01 08:11:50.688000 | Team One | 00:03:12 | 00:00:00
2020-10-01 08:18:03.520000 | Team One | 00:02:29 | 00:00:00
2020-10-01 08:20:36.364000 | Team One | 00:00:03 | 00:00:00
2020-10-01 08:26:33.528000 | Team One | 00:00:54 | 00:00:00
2020-10-01 08:28:30.289000 | Team Two | 00:09:55 | 00:00:00
2020-10-01 08:28:32.474000 | Team Two | 00:11:29 | 00:00:00
2020-10-01 08:40:45.233000 | Team Two | 00:16:49 | 00:00:00
2020-10-01 08:46:18.536000 | Team Two | 00:01:55 | 00:00:00
2020-10-01 08:49:30.508000 | Team Two | 00:04:57 | 00:00:00
2020-10-01 08:49:48.392000 | Team Two | 00:03:29 | 00:00:00
2020-10-01 08:54:19.327000 | Team Two | 00:09:39 | 00:00:00
2020-10-01 09:00:14.447000 | Team Two | 00:02:46 | 00:00:00
2020-10-01 09:03:58.350000 | Team Two | 00:00:00 | 00:06:29
2020-10-01 09:09:57.714000 | Team Two | 00:04:50 | 00:00:00
2020-10-01 09:13:37.595000 | Team Two | 00:14:21 | 00:00:00
2020-10-01 09:17:33.042000 | Team Two | 00:14:27 | 00:00:00
2020-10-01 09:27:33.261000 | Team Two | 00:02:34 | 00:00:00
2020-10-01 09:37:08.755000 | Team Two | 00:03:49 | 00:00:00
2020-10-01 09:38:41.657000 | Team Two | 00:03:27 | 00:00:00
2020-10-01 09:41:37.228000 | Team Two | 00:03:19 | 00:00:00
2020-10-01 09:43:47.520000 | Team Two | 00:02:40 | 00:00:00
2020-10-01 09:48:44.474000 | Team Two | 00:05:38 | 00:00:00
2020-10-01 09:49:42.459000 | Team Two | 00:00:30 | 00:00:00
2020-10-01 09:51:08.046000 | Team Two | 00:04:02 | 00:00:00
2020-10-01 09:51:52.486000 | Team Two | 00:06:51 | 00:00:00
2020-10-01 09:55:43.651000 | Team Two | 00:02:34 | 00:00:00
2020-10-01 09:58:26.484000 | Team Two | 00:06:23 | 00:00:00
2020-10-01 10:07:02.434000 | Team Two | 00:00:00 | 00:11:45
2020-10-01 10:07:54.609000 | Team Two | 00:00:00 | 00:18:45