I am sure this is simple for the folks who know what they are doing. But I'm stumped.



Attached is a simple spreadsheet that has columns of start/end times, and a column for the duration represented by the start/end times. I want to total the hours at the bottom of the table for the duration. But I'm not getting a correct total.

I also have a pivot table in it that I'm trying to list each category (tag) and total hours for each category. Of course, I'm not getting correct totals for that.

I'm thinking I need to format something different. Wondering if anyone here has any suggestions.

Spreadsheet attached.

Attached Files

Timesheet 9-3-14.xlsx (47.2 KB, 15 views)