Spreadsheet: 96405d1295819317-timesheet-hours-not-adding-correctly-in-a-pivot-table-761227_marvinp
Sheet: Sheet1

 |  |  | MONTHLY TIMESHEET
 | Employee Name:
Name | Date | Time in | Out | Hours | Weekday |  | Weekday | (Multiple Items)
[NAME] | 2010-01-01 00:00:00 | 08:00:00 | 12:14:00
[NAME] | 2010-01-02 00:00:00 | 08:02:00 | 12:23:00 |  |  |  | Row Labels | Sum of Hours
[NAME] | 2010-01-03 00:00:00 | 08:04:00 | 12:32:00 |  |  |  | [NAME]
[NAME] | 2010-01-04 00:00:00 | 08:06:00 | 12:41:00 |  |  |  | 12/28/2009 - 1/3/2010 | 4:14:00 | << This format is Days Hr:Min
[NAME] | 2010-01-05 00:00:00 | 08:08:00 | 12:50:00 |  |  |  | 1/4/2010 - 1/10/2010 | 1 day, 0:05:00 |  | I want it to show as
[NAME] | 2010-01-06 00:00:00 | 08:10:00 | 12:59:00 |  |  |  | 1/11/2010 - 1/17/2010 | 1 day, 4:10:00 |  | 52:14  Hours:Minutes  or
[NAME] | 2010-01-07 00:00:00 | 08:12:00 | 13:08:00 |  |  |  | 1/18/2010 - 1/24/2010 | 1 day, 8:15:00 |  | 52.233 Hours
[NAME] | 2010-01-08 00:00:00 | 08:14:00 | 13:17:00 |  |  |  | 1/25/2010 - 1/31/2010 | 1 day, 12:20:00
[NAME] | 2010-01-09 00:00:00 | 08:16:00 | 13:26:00 |  |  |  | 2/1/2010 - 2/7/2010 | 1 day, 0:10:00
[NAME] | 2010-01-10 00:00:00 | 08:18:00 | 13:35:00 |  |  |  | 2/8/2010 - 2/14/2010 | 21:15:00
[NAME] | 2010-01-11 00:00:00 | 08:20:00 | 13:44:00 |  |  |  | 2/15/2010 - 2/21/2010 | 18:20:00
[NAME] | 2010-01-12 00:00:00 | 08:22:00 | 13:53:00 |  |  |  | 2/22/2010 - 2/28/2010 | 15:25:00
[NAME] | 2010-01-13 00:00:00 | 08:24:00 | 14:02:00 |  |  |  | 3/1/2010 - 3/4/2010 | 7:45:00
[NAME] | 2010-01-14 00:00:00 | 08:26:00 | 14:11:00 |  |  |  | [NAME] | 8 days, 19:59:00
[NAME] | 2010-01-15 00:00:00 | 08:28:00 | 14:20:00 |  |  |  | [NAME]
[NAME] | 2010-01-16 00:00:00 | 08:30:00 | 14:29:00 |  |  |  | 12/28/2009 - 1/3/2010 | 5:52:00
[NAME] | 2010-01-17 00:00:00 | 08:32:00 | 14:38:00 |  |  |  | 1/4/2010 - 1/10/2010 | 1 day, 8:15:00
[NAME] | 2010-01-18 00:00:00 | 08:34:00 | 14:47:00 |  |  |  | 1/11/2010 - 1/17/2010 | 1 day, 12:20:00
[NAME] | 2010-01-19 00:00:00 | 08:36:00 | 14:56:00 |  |  |  | 1/18/2010 - 1/24/2010 | 22:20:00
[NAME] | 2010-01-20 00:00:00 | 08:38:00 | 15:05:00 |  |  |  | 1/25/2010 - 1/31/2010 | 1 day, 2:25:00
[NAME] | 2010-01-21 00:00:00 | 08:40:00 | 15:14:00 |  |  |  | 2/1/2010 - 2/7/2010 | 21:40:00
[NAME] | 2010-01-22 00:00:00 | 08:42:00 | 15:23:00 |  |  |  | 2/8/2010 - 2/14/2010 | 18:45:00
[NAME] | 2010-01-23 00:00:00 | 08:44:00 | 15:32:00 |  |  |  | 2/15/2010 - 2/21/2010 | 15:50:00
[NAME] | 2010-01-24 00:00:00 | 08:46:00 | 15:41:00 |  |  |  | 2/22/2010 - 2/28/2010 | 14:40:00
[NAME] | 2010-01-25 00:00:00 | 08:48:00 | 15:50:00 |  |  |  | 3/1/2010 - 3/4/2010 | 11:30:00
[NAME] | 2010-01-26 00:00:00 | 08:50:00 | 15:59:00 |  |  |  | [NAME] | 8 days, 13:37:00
[NAME] | 2010-01-27 00:00:00 | 08:52:00 | 16:08:00
[NAME] | 2010-01-28 00:00:00 | 08:54:00 | 16:17:00
[NAME] | 2010-01-29 00:00:00 | 08:56:00 | 16:26:00
[NAME] | 2010-01-30 00:00:00 | 08:58:00 | 16:35:00
[NAME] | 2010-01-31 00:00:00 | 09:00:00 | 16:44:00
[NAME] | 2010-02-01 00:00:00 | 13:00:00 | 18:00:00
[NAME] | 2010-02-02 00:00:00 | 13:03:00 | 17:58:00
[NAME] | 2010-02-03 00:00:00 | 13:06:00 | 17:56:00
[NAME] | 2010-02-04 00:00:00 | 13:09:00 | 17:54:00
[NAME] | 2010-02-05 00:00:00 | 13:12:00 | 17:52:00
[NAME] | 2010-02-06 00:00:00 | 13:15:00 | 17:50:00
[NAME] | 2010-02-07 00:00:00 | 13:18:00 | 17:48:00
[NAME] | 2010-02-08 00:00:00 | 13:21:00 | 17:46:00
[NAME] | 2010-02-09 00:00:00 | 13:24:00 | 17:44:00
[NAME] | 2010-02-10 00:00:00 | 13:27:00 | 17:42:00
[NAME] | 2010-02-11 00:00:00 | 13:30:00 | 17:40:00
[NAME] | 2010-02-12 00:00:00 | 13:33:00 | 17:38:00
[NAME] | 2010-02-13 00:00:00 | 13:36:00 | 17:36:00
[NAME] | 2010-02-14 00:00:00 | 13:39:00 | 17:34:00
[NAME] | 2010-02-15 00:00:00 | 13:42:00 | 17:32:00
[NAME] | 2010-02-16 00:00:00 | 13:45:00 | 17:30:00
[NAME] | 2010-02-17 00:00:00 | 13:48:00 | 17:28:00
[NAME] | 2010-02-18 00:00:00 | 13:51:00 | 17:26:00
[NAME] | 2010-02-19 00:00:00 | 13:54:00 | 17:24:00
[NAME] | 2010-02-20 00:00:00 | 13:57:00 | 17:22:00
[NAME] | 2010-02-21 00:00:00 | 14:00:00 | 17:20:00
[NAME] | 2010-02-22 00:00:00 | 14:03:00 | 17:18:00
[NAME] | 2010-02-23 00:00:00 | 14:06:00 | 17:16:00
[NAME] | 2010-02-24 00:00:00 | 14:09:00 | 17:14:00
[NAME] | 2010-02-25 00:00:00 | 14:12:00 | 17:12:00
[NAME] | 2010-02-26 00:00:00 | 14:15:00 | 17:10:00
[NAME] | 2010-02-27 00:00:00 | 14:18:00 | 17:08:00
[NAME] | 2010-02-28 00:00:00 | 14:21:00 | 17:06:00
[NAME] | 2010-03-01 00:00:00 | 14:24:00 | 17:04:00
[NAME] | 2010-03-02 00:00:00 | 14:27:00 | 17:02:00
[NAME] | 2010-03-03 00:00:00 | 14:30:00 | 17:00:00
[NAME] | 2010-01-01 00:00:00 | 08:28:00 | 14:20:00
[NAME] | 2010-01-02 00:00:00 | 08:30:00 | 14:29:00
[NAME] | 2010-01-03 00:00:00 | 08:32:00 | 14:38:00
[NAME] | 2010-01-04 00:00:00 | 08:34:00 | 14:47:00
[NAME] | 2010-01-05 00:00:00 | 08:36:00 | 14:56:00
[NAME] | 2010-01-06 00:00:00 | 08:38:00 | 15:05:00
[NAME] | 2010-01-07 00:00:00 | 08:40:00 | 15:14:00
[NAME] | 2010-01-08 00:00:00 | 08:42:00 | 15:23:00
[NAME] | 2010-01-09 00:00:00 | 08:44:00 | 15:32:00
[NAME] | 2010-01-10 00:00:00 | 08:46:00 | 15:41:00
[NAME] | 2010-01-11 00:00:00 | 08:48:00 | 15:50:00
[NAME] | 2010-01-12 00:00:00 | 08:50:00 | 15:59:00
[NAME] | 2010-01-13 00:00:00 | 08:52:00 | 16:08:00
[NAME] | 2010-01-14 00:00:00 | 08:54:00 | 16:17:00
[NAME] | 2010-01-15 00:00:00 | 08:56:00 | 16:26:00
[NAME] | 2010-01-16 00:00:00 | 08:58:00 | 16:35:00
[NAME] | 2010-01-17 00:00:00 | 09:00:00 | 16:44:00
[NAME] | 2010-01-18 00:00:00 | 08:00:00 | 12:14:00
[NAME] | 2010-01-19 00:00:00 | 08:02:00 | 12:23:00
[NAME] | 2010-01-20 00:00:00 | 08:04:00 | 12:32:00
[NAME] | 2010-01-21 00:00:00 | 08:06:00 | 12:41:00
[NAME] | 2010-01-22 00:00:00 | 08:08:00 | 12:50:00
[NAME] | 2010-01-23 00:00:00 | 08:10:00 | 12:59:00
[NAME] | 2010-01-24 00:00:00 | 08:12:00 | 13:08:00
[NAME] | 2010-01-25 00:00:00 | 08:14:00 | 13:17:00
[NAME] | 2010-01-26 00:00:00 | 08:16:00 | 13:26:00
[NAME] | 2010-01-27 00:00:00 | 08:18:00 | 13:35:00
[NAME] | 2010-01-28 00:00:00 | 08:20:00 | 13:44:00
[NAME] | 2010-01-29 00:00:00 | 08:22:00 | 13:53:00
[NAME] | 2010-01-30 00:00:00 | 08:24:00 | 14:02:00
[NAME] | 2010-01-31 00:00:00 | 08:26:00 | 14:11:00
[NAME] | 2010-02-01 00:00:00 | 13:18:00 | 17:48:00
[NAME] | 2010-02-02 00:00:00 | 13:21:00 | 17:46:00
[NAME] | 2010-02-03 00:00:00 | 13:24:00 | 17:44:00
[NAME] | 2010-02-04 00:00:00 | 13:27:00 | 17:42:00
[NAME] | 2010-02-05 00:00:00 | 13:30:00 | 17:40:00
[NAME] | 2010-02-06 00:00:00 | 13:33:00 | 17:38:00
[NAME] | 2010-02-07 00:00:00 | 13:36:00 | 17:36:00
[NAME] | 2010-02-08 00:00:00 | 13:39:00 | 17:34:00
[NAME] | 2010-02-09 00:00:00 | 13:42:00 | 17:32:00
[NAME] | 2010-02-10 00:00:00 | 13:45:00 | 17:30:00
[NAME] | 2010-02-11 00:00:00 | 13:48:00 | 17:28:00
[NAME] | 2010-02-12 00:00:00 | 13:51:00 | 17:26:00
[NAME] | 2010-02-13 00:00:00 | 13:54:00 | 17:24:00
[NAME] | 2010-02-14 00:00:00 | 13:57:00 | 17:22:00
[NAME] | 2010-02-15 00:00:00 | 14:00:00 | 17:20:00
[NAME] | 2010-02-16 00:00:00 | 14:03:00 | 17:18:00
[NAME] | 2010-02-17 00:00:00 | 14:06:00 | 17:16:00
[NAME] | 2010-02-18 00:00:00 | 14:09:00 | 17:14:00
[NAME] | 2010-02-19 00:00:00 | 14:12:00 | 17:12:00
[NAME] | 2010-02-20 00:00:00 | 14:15:00 | 17:10:00
[NAME] | 2010-02-21 00:00:00 | 14:18:00 | 17:08:00
[NAME] | 2010-02-22 00:00:00 | 14:21:00 | 17:06:00
[NAME] | 2010-02-23 00:00:00 | 14:24:00 | 17:04:00
[NAME] | 2010-02-24 00:00:00 | 14:27:00 | 17:02:00
[NAME] | 2010-02-25 00:00:00 | 14:30:00 | 17:00:00
[NAME] | 2010-02-26 00:00:00 | 13:30:00 | 17:40:00
[NAME] | 2010-02-27 00:00:00 | 13:33:00 | 17:38:00
[NAME] | 2010-02-28 00:00:00 | 13:36:00 | 17:36:00
[NAME] | 2010-03-01 00:00:00 | 13:39:00 | 17:34:00
[NAME] | 2010-03-02 00:00:00 | 13:42:00 | 17:32:00
[NAME] | 2010-03-03 00:00:00 | 13:45:00 | 17:30:00