Spreadsheet: 169443d1342845299-how-to-calculate-monthly-average-worksheet
Sheet: CSR TIMES

 | LOGIN |  |  |  |  | LOGOUT |  |  |  |  |  |  |  | AWAY FROM DESK |  | LUNCH
 | I3 | SIEBLE |  |  |  | I3 |  |  |  | SIEBLE |  |  | 4 | OUT | IN | OUT | IN
2012-06-20 00:00:00 | 10:07:00 | 10:09:00 |  |  |  |  |  |  |  |  |  |  |  | 12:08:00 | 12:11:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 03:55:00 | 03:55:00 | 02:43:00 | 03:12:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 03:59:00 | 04:07:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | total | 11 | total | 29
2012-06-21 00:00:00 | 05:54:00 | 05:57:00 |  |  |  |  |  |  |  |  |  |  |  | 07:06:00 | 07:14:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:53:00 | 07:55:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 08:13:00 | 08:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 09:11:00 | 09:14:00 | 10:52:00 | 11:21:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 12;09 | 12;16
 |  |  |  |  |  |  |  |  |  |  |  |  |  | total | 22 | total | 29
2012-06-22 00:00:00 | 09:56:00 | 10:00:00 |  |  |  |  |  |  |  |  |  |  |  | 10:20:00 | 10:26:00 | 02:31:00 | 03:03:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 10;53 | 10;55
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 05:26:00 | 05:29:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | total | 11 | total | 32
2012-06-23 00:00:00 | 11:00:00 | 11:04:00 |  |  |  |  |  |  |  |  |  |  |  | 03:38:00 | 03:46:00 | 02:30:00 | 03:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | total | 8 | total | 30
2012-06-25 00:00:00 | 09:55:00 | 09:57:00 |  |  |  |  |  |  |  |  |  |  |  | 11:59:00 | 12:02:00 | 01:30:00 | 01:59:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 02:55:00 | 03:03:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 04:37:00 | 04:39:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 05:13:00 | 05:17:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | total | 17 | total | 29
2012-06-26 00:00:00 | 06:00:00 | 06:06:00 |  |  |  |  |  |  |  |  |  |  |  | 07:44:00 | 07:49:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 10:09:00 | 10:14:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 11:30:00 | 11:35:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | total | 15 | total | 30
2012-06-27 00:00:00 | 09:57:00 | 10:05:00 |  |  |  |  |  |  |  |  |  |  |  | 12:34:00 | 12:40:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 04:17:00 | 04:24:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 05:39:00 | 05:49:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | total | 23 | total | 30
2012-06-28 00:00:00 | 06:58:00 | 06:03:00 |  |  |  |  |  |  |  |  |  |  |  | 08:38:00 | 08:39:00 | 10:45:00 | 11:13:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 09:58:00 | 10:02:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 12:24:00 | 12:34:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | total | 15 | total | 30
2012-06-29 00:00:00 | 09:57:00 | 09:59:00 |  |  |  |  |  |  |  |  |  |  |  | 02:47:00 | 02:57:00 | 01:55:00 | 02:28:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | total | 10 | total | 30
2012-06-30 00:00:00 | 10:58:00 | 11:00:00 |  |  |  |  |  |  |  |  |  |  |  | 04:18:00 | 04:28:00 | 03:02:00 | 03:31:00
 | LOGIN |  |  |  |  | LOGOUT |  |  |  |  |  |  |  | AWAY FROM DESK |  | LUNCH
 | I3 | SIEBLE |  |  |  | I3 |  |  |  | SIEBLE |  |  | 4 | OUT | IN | OUT | IN
2012-07-02 00:00:00 | 10:58:00 | 11:04:00 |  |  |  |  |  |  |  |  |  |  |  | 01:09:00 | 01:14:00 | 03:39:00 | 04:09:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 05:04:00 | 05:14:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | total | 15 | total | 30
2012-07-03 00:00:00 | 11:01:00 | 11:04:00 |  |  |  |  |  |  |  |  |  |  |  | 01:07:00 | 01:11:00 | 03:51:00 | 04:13:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 04:35:00 | 04:44:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | total | 13 | total | 30
2012-07-04 00:00:00 | 10:52:00 | 10:58:00 |  |  |  |  |  |  |  |  |  |  |  | 02:38:00 | 02:41:00 | 03:31:00 | 04:02:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 05:39:00 | 05:54:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | total | 18 | total | 31
2012-07-05 00:00:00 | Computer Change
 |  |  |  |  |  |  |  |  |  |  |  |  |  | total |  | total
2012-07-06 00:00:00 | 10:58:00 | 11:02:00 |  |  |  |  |  |  |  |  |  |  |  | 11:41:00 | 11:49:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 05:10:00 | 05:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | total |  | total
2012-07-07 00:00:00 | 08:02:00 | 08:04:00 |  |  |  |  |  |  |  |  |  |  |  | 09:19:00 | 09:27:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 10:35:00 | 10:41:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | total |  | total
2012-07-08 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | total |  | total
 |  |  |  |  |  |  |  |  |  |  |  |  |  | total |  | total
 |  |  |  |  |  |  |  |  |  |  |  |  |  | total |  | total