Spreadsheet: 96404d1295818964-timesheet-hours-not-adding-correctly-in-a-pivot-table-timesheet-hours-not-1904
Sheet: Sheet1

 |  |  | MONTHLY TIMESHEET
 | Employee Name:
Name | Date | Time in | Out | Hours | Weekday
[NAME] | 2011-01-01 00:00:00 | 08:00:00 | 12:14:00 |  |  |  | Weekday | (Multiple Items)
[NAME] | 2011-01-02 00:00:00 | 08:02:00 | 12:23:00
[NAME] | 2011-01-03 00:00:00 | 08:04:00 | 12:32:00 |  |  |  | Row Labels | Sum of Hours
[NAME] | 2011-01-04 00:00:00 | 08:06:00 | 12:41:00 |  |  |  | [NAME] | 4 days, 1:10:00
[NAME] | 2011-01-05 00:00:00 | 08:08:00 | 12:50:00 |  |  |  | 12/26/2010 - 1/1/2011 | 9:14:00 |  | << These numbers are correct
[NAME] | 2011-01-06 00:00:00 | 08:10:00 | 12:59:00 |  |  |  | 1/2/2011 - 1/8/2011 | 18:44:00 |  | They are now Hours:Minutes Format
[NAME] | 2011-01-07 00:00:00 | 08:12:00 | 13:08:00 |  |  |  | 1/9/2011 - 1/15/2011 | 19:12:00
[NAME] | 2011-01-08 00:00:00 | 08:14:00 | 13:17:00 |  |  |  | 1/16/2011 - 1/22/2011 | 19:40:00 |  | Things to look at
[NAME] | 2011-01-09 00:00:00 | 08:16:00 | 13:26:00 |  |  |  | 1/23/2011 - 1/29/2011 | 20:08:00 |  | Refresh Pivot Table after changing data
[NAME] | 2011-01-10 00:00:00 | 08:18:00 | 13:35:00 |  |  |  | 1/30/2011 - 2/1/2011 | 10:12:00 |  | MAKE SURE you are not using 1904 Data
[NAME] | 2011-01-11 00:00:00 | 08:20:00 | 13:44:00 |  |  |  | [NAME] | 4 days, 1:32:00 |  | Make the grouping start data a Sunday
[NAME] | 2011-01-12 00:00:00 | 08:22:00 | 13:53:00 |  |  |  | 12/26/2010 - 1/1/2011 | 10:22:00 |  | Filter the Weekdays to your choice.
[NAME] | 2011-01-13 00:00:00 | 08:24:00 | 14:02:00 |  |  |  | 1/2/2011 - 1/8/2011 | 21:00:00
[NAME] | 2011-01-14 00:00:00 | 08:26:00 | 14:11:00 |  |  |  | 1/9/2011 - 1/15/2011 | 21:28:00
[NAME] | 2011-01-15 00:00:00 | 08:28:00 | 14:20:00 |  |  |  | 1/16/2011 - 1/22/2011 | 18:19:00
[NAME] | 2011-01-16 00:00:00 | 08:30:00 | 14:29:00 |  |  |  | 1/23/2011 - 1/29/2011 | 16:55:00
[NAME] | 2011-01-17 00:00:00 | 08:32:00 | 14:38:00 |  |  |  | 1/30/2011 - 2/1/2011 | 9:28:00
[NAME] | 2011-01-18 00:00:00 | 08:34:00 | 14:47:00 |  |  |  | Grand Total | 8 days, 2:42:00
[NAME] | 2011-01-19 00:00:00 | 08:36:00 | 14:56:00
[NAME] | 2011-01-20 00:00:00 | 08:38:00 | 15:05:00
[NAME] | 2011-01-21 00:00:00 | 08:40:00 | 15:14:00
[NAME] | 2011-01-22 00:00:00 | 08:42:00 | 15:23:00
[NAME] | 2011-01-23 00:00:00 | 08:44:00 | 15:32:00
[NAME] | 2011-01-24 00:00:00 | 08:46:00 | 15:41:00
[NAME] | 2011-01-25 00:00:00 | 08:48:00 | 15:50:00
[NAME] | 2011-01-26 00:00:00 | 08:50:00 | 15:59:00
[NAME] | 2011-01-27 00:00:00 | 08:52:00 | 16:08:00
[NAME] | 2011-01-28 00:00:00 | 08:54:00 | 16:17:00
[NAME] | 2011-01-29 00:00:00 | 08:56:00 | 16:26:00
[NAME] | 2011-01-30 00:00:00 | 08:58:00 | 16:35:00
[NAME] | 2011-01-31 00:00:00 | 09:00:00 | 16:44:00
[NAME] | 2011-01-01 00:00:00 | 13:00:00 | 18:00:00
[NAME] | 2011-01-02 00:00:00 | 13:03:00 | 17:58:00
[NAME] | 2011-01-03 00:00:00 | 13:06:00 | 17:56:00
[NAME] | 2011-01-04 00:00:00 | 13:09:00 | 17:54:00
[NAME] | 2011-01-05 00:00:00 | 13:12:00 | 17:52:00
[NAME] | 2011-01-06 00:00:00 | 13:15:00 | 17:50:00
[NAME] | 2011-01-07 00:00:00 | 13:18:00 | 17:48:00
[NAME] | 2011-01-08 00:00:00 | 13:21:00 | 17:46:00
[NAME] | 2011-01-09 00:00:00 | 13:24:00 | 17:44:00
[NAME] | 2011-01-10 00:00:00 | 13:27:00 | 17:42:00
[NAME] | 2011-01-11 00:00:00 | 13:30:00 | 17:40:00
[NAME] | 2011-01-12 00:00:00 | 13:33:00 | 17:38:00
[NAME] | 2011-01-13 00:00:00 | 13:36:00 | 17:36:00
[NAME] | 2011-01-14 00:00:00 | 13:39:00 | 17:34:00
[NAME] | 2011-01-15 00:00:00 | 13:42:00 | 17:32:00
[NAME] | 2011-01-16 00:00:00 | 13:45:00 | 17:30:00
[NAME] | 2011-01-17 00:00:00 | 13:48:00 | 17:28:00
[NAME] | 2011-01-18 00:00:00 | 13:51:00 | 17:26:00
[NAME] | 2011-01-19 00:00:00 | 13:54:00 | 17:24:00
[NAME] | 2011-01-20 00:00:00 | 13:57:00 | 17:22:00
[NAME] | 2011-01-21 00:00:00 | 14:00:00 | 17:20:00
[NAME] | 2011-01-22 00:00:00 | 14:03:00 | 17:18:00
[NAME] | 2011-01-23 00:00:00 | 14:06:00 | 17:16:00
[NAME] | 2011-01-24 00:00:00 | 14:09:00 | 17:14:00
[NAME] | 2011-01-25 00:00:00 | 14:12:00 | 17:12:00
[NAME] | 2011-01-26 00:00:00 | 14:15:00 | 17:10:00
[NAME] | 2011-01-27 00:00:00 | 14:18:00 | 17:08:00
[NAME] | 2011-01-28 00:00:00 | 14:21:00 | 17:06:00
[NAME] | 2011-01-29 00:00:00 | 14:24:00 | 17:04:00
[NAME] | 2011-01-30 00:00:00 | 14:27:00 | 17:02:00
[NAME] | 2011-01-31 00:00:00 | 14:30:00 | 17:00:00
[NAME] | 2011-01-01 00:00:00 | 08:28:00 | 14:20:00
[NAME] | 2011-01-02 00:00:00 | 08:30:00 | 14:29:00
[NAME] | 2011-01-03 00:00:00 | 08:32:00 | 14:38:00
[NAME] | 2011-01-04 00:00:00 | 08:34:00 | 14:47:00
[NAME] | 2011-01-05 00:00:00 | 08:36:00 | 14:56:00
[NAME] | 2011-01-06 00:00:00 | 08:38:00 | 15:05:00
[NAME] | 2011-01-07 00:00:00 | 08:40:00 | 15:14:00
[NAME] | 2011-01-08 00:00:00 | 08:42:00 | 15:23:00
[NAME] | 2011-01-09 00:00:00 | 08:44:00 | 15:32:00
[NAME] | 2011-01-10 00:00:00 | 08:46:00 | 15:41:00
[NAME] | 2011-01-11 00:00:00 | 08:48:00 | 15:50:00
[NAME] | 2011-01-12 00:00:00 | 08:50:00 | 15:59:00
[NAME] | 2011-01-13 00:00:00 | 08:52:00 | 16:08:00
[NAME] | 2011-01-14 00:00:00 | 08:54:00 | 16:17:00
[NAME] | 2011-01-15 00:00:00 | 08:56:00 | 16:26:00
[NAME] | 2011-01-16 00:00:00 | 08:58:00 | 16:35:00
[NAME] | 2011-01-17 00:00:00 | 09:00:00 | 16:44:00
[NAME] | 2011-01-18 00:00:00 | 08:00:00 | 12:14:00
[NAME] | 2011-01-19 00:00:00 | 08:02:00 | 12:23:00
[NAME] | 2011-01-20 00:00:00 | 08:04:00 | 12:32:00
[NAME] | 2011-01-21 00:00:00 | 08:06:00 | 12:41:00
[NAME] | 2011-01-22 00:00:00 | 08:08:00 | 12:50:00
[NAME] | 2011-01-23 00:00:00 | 08:10:00 | 12:59:00
[NAME] | 2011-01-24 00:00:00 | 08:12:00 | 13:08:00
[NAME] | 2011-01-25 00:00:00 | 08:14:00 | 13:17:00
[NAME] | 2011-01-26 00:00:00 | 08:16:00 | 13:26:00
[NAME] | 2011-01-27 00:00:00 | 08:18:00 | 13:35:00
[NAME] | 2011-01-28 00:00:00 | 08:20:00 | 13:44:00
[NAME] | 2011-01-29 00:00:00 | 08:22:00 | 13:53:00
[NAME] | 2011-01-30 00:00:00 | 08:24:00 | 14:02:00
[NAME] | 2011-01-31 00:00:00 | 08:26:00 | 14:11:00
[NAME] | 2011-01-01 00:00:00 | 13:18:00 | 17:48:00
[NAME] | 2011-01-02 00:00:00 | 13:21:00 | 17:46:00
[NAME] | 2011-01-03 00:00:00 | 13:24:00 | 17:44:00
[NAME] | 2011-01-04 00:00:00 | 13:27:00 | 17:42:00
[NAME] | 2011-01-05 00:00:00 | 13:30:00 | 17:40:00
[NAME] | 2011-01-06 00:00:00 | 13:33:00 | 17:38:00
[NAME] | 2011-01-07 00:00:00 | 13:36:00 | 17:36:00
[NAME] | 2011-01-08 00:00:00 | 13:39:00 | 17:34:00
[NAME] | 2011-01-09 00:00:00 | 13:42:00 | 17:32:00
[NAME] | 2011-01-10 00:00:00 | 13:45:00 | 17:30:00
[NAME] | 2011-01-11 00:00:00 | 13:48:00 | 17:28:00
[NAME] | 2011-01-12 00:00:00 | 13:51:00 | 17:26:00
[NAME] | 2011-01-13 00:00:00 | 13:54:00 | 17:24:00
[NAME] | 2011-01-14 00:00:00 | 13:57:00 | 17:22:00
[NAME] | 2011-01-15 00:00:00 | 14:00:00 | 17:20:00
[NAME] | 2011-01-16 00:00:00 | 14:03:00 | 17:18:00
[NAME] | 2011-01-17 00:00:00 | 14:06:00 | 17:16:00
[NAME] | 2011-01-18 00:00:00 | 14:09:00 | 17:14:00
[NAME] | 2011-01-19 00:00:00 | 14:12:00 | 17:12:00
[NAME] | 2011-01-20 00:00:00 | 14:15:00 | 17:10:00
[NAME] | 2011-01-21 00:00:00 | 14:18:00 | 17:08:00
[NAME] | 2011-01-22 00:00:00 | 14:21:00 | 17:06:00
[NAME] | 2011-01-23 00:00:00 | 14:24:00 | 17:04:00
[NAME] | 2011-01-24 00:00:00 | 14:27:00 | 17:02:00
[NAME] | 2011-01-25 00:00:00 | 14:30:00 | 17:00:00
[NAME] | 2011-01-26 00:00:00 | 13:30:00 | 17:40:00
[NAME] | 2011-01-27 00:00:00 | 13:33:00 | 17:38:00
[NAME] | 2011-01-28 00:00:00 | 13:36:00 | 17:36:00
[NAME] | 2011-01-29 00:00:00 | 13:39:00 | 17:34:00
[NAME] | 2011-01-30 00:00:00 | 13:42:00 | 17:32:00
[NAME] | 2011-01-31 00:00:00 | 13:45:00 | 17:30:00