Spreadsheet: 703976d1605279224-sum-of-time-and-time-total-over-24-hours-and-over-a-series-of-dates-adding-time
Sheet: Sheet1

Date | Time In | Time Out
2020-10-01 00:00:00 | 15:12:00 | 16:03:00
 | 15:12:00 | 16:03:00
 | 15:12:00 | 16:03:00
 | 15:30:00 | 16:03:00
 | 15:16:00 | 16:03:00
 | 15:12:00 | 16:03:00
 | 15:16:00 | 16:03:00
 | 15:30:00 | 16:03:00
 | 15:12:00 | 16:03:00
 | 15:30:00 | 16:03:00
 | 15:30:00 | 16:03:00
 | 15:30:00 | 16:03:00
 | 15:15:00 | 16:00:00
 | 14:00:00 | 19:00:00
 | 14:00:00 | 19:00:00
 | 14:00:00 | 19:00:00
 | 14:00:00 | 19:00:00
Total
2020-10-02 00:00:00 | 08:00:00 | 13:00:00
 | 09:00:00 | 13:00:00
 | 08:00:00 | 15:15:00
 | 09:00:00 | 15:15:00
 | 17:44:00 | 21:15:00
Total
2020-10-03 00:00:00 | 09:45:00 | 11:45:00
 | 12:00:00 | 15:00:00
 | 12:00:00 | 18:00:00
 | 07:50:00 | 22:00:00
Total
2020-10-04 00:00:00 | 08:45:00 | 15:30:00
 | 09:06:00 | 12:30:00
 | 09:00:00 | 10:20:00
 | 09:00:00 | 11:00:00
 | 08:44:00 | 17:00:00
 | 13:00:00 | 16:15:00
 | 08:50:00 | 13:05:00
 | 08:45:00 | 16:00:00
 | 09:00:00 | 11:00:00
 | 08:40:00 | 10:00:00
 | 08:00:00 | 17:00:00
 | 08:40:00 | 16:50:00
 | 09:00:00 | 17:00:00
 | 09:05:00 | 17:00:00
 | 09:00:00 | 10:00:00
 | 08:55:00 | 16:00:00
 | 08:30:00 | 12:00:00
 | 15:00:00 | 16:15:00
 | 18:30:00 | 23:00:00
Total
2020-10-05 00:00:00 | 09:00:00 | 16:30:00
 | 08:35:00 | 16:30:00
 | 08:00:00 | 18:40:00
 | 08:45:00 | 17:00:00
 | 08:35:00 | 16:30:00
 | 08:45:00 | 16:30:00
 | 08:47:00 | 16:30:00
 | 08:40:00 | 16:30:00
 | 08:50:00 | 15:30:00
 | 08:00:00 | 18:40:00
 | 09:00:00 | 18:40:00
 | 08:45:00 | 16:30:00
 | 09:00:00 | 10:15:00
 | 08:55:00 | 09:45:00
 | 07:00:00 | 19:00:00
 | 08:35:00 | 12:00:00
 | 15:30:00 | 16:25:00
 | 18:00:00 | 21:30:00
Total
2020-10-06 00:00:00 | 08:35:00 | 17:20:00
 | 08:30:00 | 16:30:00
 | 09:00:00 | 16:30:00
 | 08:40:00 | 16:35:00
 | 08:30:00 | 18:00:00
 | 08:50:00 | 11:00:00
 | 08:52:00 | 17:22:00
 | 08:50:00 | 09:45:00
 | 08:50:00 | 16:00:00
 | 08:50:00 | 12:00:00
 | 07:41:00 | 17:15:00
 | 08:30:00 | 16:30:00
 | 11:02:00 | 11:40:00
 | 08:45:00 | 19:00:00
 | 08:50:00 | 16:30:00
 | 09:05:00 | 16:30:00
 | 07:00:00 | 19:00:00
 | 15:30:00 | 16:20:00
 | 15:55:00 | 16:15:00
 | 20:00:00 | 21:30:00
Total
2020-10-07 00:00:00 | 08:45:00 | 18:00:00
 | 09:00:00 | 16:30:00
 | 09:00:00 | 16:30:00
 | 08:30:00 | 17:30:00
 | 08:25:00 | 16:40:00
 | 08:50:00 | 16:00:00
 | 08:45:00 | 12:00:00
 | 09:00:00 | 16:35:00
 | 08:55:00 | 16:30:00
 | 08:55:00 | 16:00:00
 | 08:00:00 | 20:20:00
 | 08:00:00 | 16:45:00
 | 09:00:00 | 10:30:00
 | 08:45:00 | 16:30:00
 | 09:00:00 | 16:30:00
 | 08:45:00 | 11:30:00
 | 07:00:00 | 21:00:00
 | 08:42:00 | 09:35:00
 | 11:50:00 | 19:20:00
Total
2020-10-08 00:00:00 | 08:10:00 | 16:50:00
 | 09:00:00 | 16:30:00
 | 08:00:00 | 17:30:00
 | 08:30:00 | 16:50:00
 | 08:30:00 | 16:30:00
 | 08:45:00 | 12:25:00
 | 08:50:00 | 16:00:00
 | 08:45:00 | 12:45:00
 | 08:50:00 | 11:00:00
 | 08:40:00 | 16:00:00
 | 08:30:00 | 12:45:00
 | 08:15:00 | 16:25:00
 | 08:30:00 | 16:30:00
 | 07:00:00 | 15:30:00
 | 08:30:00 | 16:30:00
 | 08:30:00 | 16:30:00
 | 08:30:00 | 16:45:00
 | 08:50:00 | 09:45:00
 | 08:45:00 | 16:00:00
 | 18:00:00 | 22:00:00
Total
2020-10-09 00:00:00 | 06:00:00 | 16:00:00
 | 18:00:00 | 21:30:00
Total
2020-10-10 00:00:00 | 07:00:00 | 14:00:00
 | 16:00:00 | 22:30:00
Total
2020-10-11 00:00:00 | 08:40:00 | 16:25:00
 | 08:45:00 | 16:00:00
 | 08:00:00 | 16:00:00
 | 08:00:00 | 18:00:00
 | 08:00:00 | 16:30:00
 | 10:30:00 | 16:00:00
 | 08:30:00 | 16:30:00
 | 08:45:00 | 17:00:00
 | 09:05:00 | 12:10:00
 | 08:00:00 | 16:30:00
 | 08:40:00 | 16:30:00
 | 08:30:00 | 16:30:00
 | 08:20:00 | 16:30:00
 | 07:50:00 | 16:30:00
 | 07:50:00 | 17:45:00
 | 08:20:00 | 16:45:00
 | 08:30:00 | 16:30:00
 | 08:15:00 | 16:45:00
 | 09:30:00 | 16:45:00
 | 07:30:00 | 16:00:00
 | 08:30:00 | 16:35:00
 | 07:10:00 | 18:00:00
 | 08:30:00 | 17:15:00
 | 08:15:00 | 18:00:00
 | 08:30:00 | 12:30:00
 | 19:00:00 | 21:30:00
 | 20:00:00 | 22:50:00
Total
2020-10-12 00:00:00 | 08:00:00 | 16:20:00
 | 08:45:00 | 16:30:00
 | 08:10:00 | 16:10:00
 | 08:20:00 | 17:40:00
 | 08:00:00 | 17:10:00
 | 08:28:00 | 15:00:00
 | 08:00:00 | 17:10:00
 | 08:00:00 | 16:30:00
 | 08:45:00 | 18:00:00
 | 08:00:00 | 16:30:00
 | 08:00:00 | 16:45:00
 | 08:45:00 | 16:30:00
 | 08:00:00 | 16:30:00
 | 08:00:00 | 16:45:00
 | 08:00:00 | 16:30:00
 | 08:30:00 | 16:30:00
 | 08:15:00 | 17:00:00
 | 08:45:00 | 17:00:00
 | 08:00:00 | 16:00:00
 | 08:30:00 | 16:25:00
 | 07:00:00 | 19:15:00
 | 08:40:00 | 16:30:00
 | 08:30:00 | 16:30:00
 | 08:45:00 | 17:00:00
 | 20:00:00 | 21:20:00
 | 22:00:00 | 00:00:00
 | 20:30:00 | 22:00:00
Total
2020-10-13 00:00:00 | 08:10:00 | 16:50:00
 | 08:20:00 | 16:20:00
 | 08:10:00 | 17:20:00
 | 08:00:00 | 17:50:00
 | 08:30:00 | 16:30:00
 | 08:00:00 | 16:00:00
 | 08:45:00 | 17:30:00
 | 08:35:00 | 16:30:00
 | 08:45:00 | 18:00:00
 | 08:45:00 | 16:00:00
 | 10:00:00 | 16:30:00
 | 07:30:00 | 17:00:00
 | 08:30:00 | 17:15:00
 | 08:30:00 | 16:30:00
 | 08:45:00 | 18:00:00
 | 08:15:00 | 18:00:00
 | 08:00:00 | 16:00:00
 | 08:25:00 | 16:30:00
 | 07:10:00 | 18:45:00
 | 08:40:00 | 16:30:00
 | 08:30:00 | 17:37:00
 | 08:25:00 | 17:30:00
 | 08:30:00 | 16:45:00
 | 08:30:00 | 18:00:00
 | 19:00:00 | 20:10:00
 | 19:38:00 | 22:00:00
 | 21:00:00 | 00:30:00
Total
Total